How to retrieve from two tables with same foreign key repeated more than once?
- by Sarenya
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?