Hi,
I forgot again how to create query that contains group of records of parent table and then details of child. I think this is done with either subquery or derived query but I can't remember which one and how.
Here is an example.
Table 1 parent with columns FLD1, FLD2
Table 2 is a child table with a FK column FLD1 (matching FLD1 in Table1)
I want to create a query that groups by Table 1 FLD1, FLD2 and contains all columns of table Table2
For example,
select Table1.FLD1, Table1.FLD2 -- add all columns from Table2 -- from Table2 group by Table1.FLD1, Table1.FLD2
TIA.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham