Hi,
In my RDBMS I have the structure of a header file containing a small number of fields then a detail table containing the detail, there can be many detail record per header record. This is fairly standard in a RDBMS structure. My question is , Is there a 'preferred'/'correct' method for creating one QV table containing all the data ? I am currently using a outer join.
Thanks,
Gavin.