Click here to Skip to main content
12,749,046 members (36,193 online)
Rate this:
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
Updated 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 6-Oct-12 0:50am
I have already implemented this but I am not getting the exact result
Tejas Vaishnav 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 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
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170215.1 | Last Updated 6 Oct 2012
Copyright © CodeProject, 1999-2017
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