Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
I have three tables table1(main table),table2,table3. table1 contains table1Id,table2 and table3 contains table2Id,table2RoleId,table3Id,table3RoleId.
with the same value of table1Id,more than one record in table2Id and table3Id but the table2RoleId's and table3RoleId's are different.
I want to join table1 with table2 and table3 to display like Table2RoleId and Table3RoleId has to display according to the Table1Id
Posted 5-Oct-12 19:16pm
Edited 5-Oct-12 19:17pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

please refer this links..
Master-Detail Join[^]
One to many join[^]
charan1431 at 6-Oct-12 0:50am
I have already implemented this but I am not getting the exact result
Tejas Vaishnav at 6-Oct-12 2:04am
so please use a Improve Question functionality and provide your data as well as also provide desired output. with your already tried query.
Strange_Pirate at 18-Mar-13 8:29am
And one request to you too.
Please use proper ENGLISH

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Zoltán Zörgő 370
1 Sergey Alexandrovich Kryukov 200
2 Peter Leow 179
3 OriginalGriff 160
4 88388132 128
0 Sergey Alexandrovich Kryukov 8,348
1 OriginalGriff 6,396
2 Peter Leow 3,557
3 Zoltán Zörgő 3,221
4 Richard MacCutchan 2,397

Advertise | Privacy | Mobile
Web02 | 2.8.150123.1 | Last Updated 6 Oct 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100