Online Library Internet News Internet Investing Internet Technology Windows Internet Tech.
Common examples are authors to books written, students to courses, and customers to orders.
When you want to get all of the master-detail data, there are two traditional ways of completing the task. Select MasterTable.fieldlist, DetailTable.fieldlist from MasterTable join DetailTable on MasterTable. Each of these methods has its flaws. The first method, using a join, may result in a tremendous amount of duplicated data. It will return in each row all of the Master data and then the associated detail data.