i am new in server 2008,
i have two tables 1 is Students
structure of students table is.
roll sname scity
and second table is marks,
structure of marks table is.
roll sub1 sub2 sub3
i want to get student detail and total of marks in a join query so what i do..
Its should be simple.
Select A.Sname, B.Sub1,B.sub2, B.sub3 From Students with(nolock) Inner Join Marks with (Nolock)
Select A.Sname, Sum (B.Sub1+B.sub2+B.sub3 ) From Students with(nolock) Inner Join Marks with (Nolock)
On A.roll=B.roll Group by A.Sname
Thanks Mr. Srinivasan sir...
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?