Click here to Skip to main content
Sign Up to vote bad
good
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 - 18:16
Edited 5 Oct '12 - 18:17


1 solution

please refer this links..
 
Master-Detail Join[^]
 
One to many join[^]
  Permalink  
Comments
charan1431 - 6 Oct '12 - 0:50
I have already implemented this but I am not getting the exact result
Tejas Vaishnav - 6 Oct '12 - 2:04
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 - 18 Mar '13 - 8:29
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
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 508
1 Arun Vasu 275
2 Maciej Los 228
3 OriginalGriff 215
4 Rohan Leuva 176
0 Sergey Alexandrovich Kryukov 9,670
1 OriginalGriff 7,409
2 CPallini 3,968
3 Rohan Leuva 3,352
4 Maciej Los 2,861


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