Inner join | sql server | 2005-2008 | join query

SELECT        feesentry_tb.Paidfee, feesentry_tb.remain_fee, student.stud_fees
FROM            feesentry_tb INNER JOIN
                         student ON feesentry_tb.stud_rollno = student.stud_roll
                       
                         the above query showa inner join in sql server 2005 -2008.


SELECT        Paidfee, remain_fee,stud_fees
FROM            feesentry_tb INNER JOIN
                         student ON feesentry_tb.stud_rollno = student.stud_roll

second way to write inner join .

Share This