Click here to Skip to main content
Rate this: bad
good
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 18:16pm
Edited 5-Oct-12 18:17pm
v2

1 solution

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

Solution 1

please refer this links..
 
Master-Detail Join[^]
 
One to many join[^]
  Permalink  
Comments
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 CHill60 360
1 Sarvesh Kumar Gupta 238
2 OriginalGriff 218
3 Sergey Alexandrovich Kryukov 153
4 DamithSL 153


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