Master detail report

  • Thread starter Thread starter Lydia
  • Start date Start date
L

Lydia

I am trying to figure out how to show all rows from a master table even if
the detail table does not have records for some rows.
 
Lydia,

You left out quite a bit of detail, but I'm guessing that you are trying to
build either a query or report from a master and detail table. When you join
the two tables, you want do a Left Join where you include all records from
the master table and only those records from the detail table where the
joined fields are equal".

You need to build a query and join the two tables. The SQL should look like:

SELECT tblClass.ClassNo, tblLookUpD.LongDesc
FROM tblClass LEFT JOIN tblLookUpD ON tblClass.ClassName = tblLookUpD.CodeKey;


Good luck,


Dennis
 
This is basically a query question. Use a LEFT or RIGHT JOIN that includes
all the records from the Master table.
 
Back
Top