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
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)