How to retrieve from two tables with same foreign key repeated more than once?

Posted by Sarenya on Stack Overflow See other posts from Stack Overflow or by Sarenya
Published on 2010-06-05T11:45:50Z Indexed on 2010/06/05 12:22 UTC
Read the original article Hit count: 129

Filed under:

How to display the data of tables that are linked by a primary key and foreign key where the foreign key of the data repeats?
For ex. I have two tables, ParentTable and Childtable.
The primary key of ParentTable acts as the foreign key of ChildTable.
There are more than one record with same ParentId in ChildTable. How to retrieve them and display in a single Grid or List or any type of view?

© Stack Overflow or respective owner

Related posts about c#4.0