Thankx for giving reply
Here i am using Join like this geting all the infromation in table3 with table1 with Ischeck true or false
SELECT T1.ID As InfromationID,I nfromation,
CASE WHEN MemberId= @MemberId(Eg=1) THEN 'TRUE' ELSE 'FALSE' END AS IsChecked
FROM tbltable1 T1 LEFT JOIN tbltable3 T3 ON
T1.InfromationI D = T3.InfromationI D
for example : in table 3 member 1 and 3 selected information...
Bethanabatla
Last Activity: Jan 19 '11, 10:33 AM
Joined: Dec 29 '10
Location:
-
Bethanabatla started a topic Get all Records from table1 and the correspond values from table3 verify MId table2in SQL ServerGet all Records from table1 and the correspond values from table3 verify MId table2
Table 1
ID Information
1 This is Key
2 This is Ball
3 This is Bike
4 This is Pen
5 This is Car
Table 2
ID Member
1 Chandra
2 Prasad
3 Rajesh
Table 3
ID Id.Member Id.Infromation
1 1 5
2 1 1
3 2 2
4 3 1
...
No activity results to display
Leave a comment: