Table Joins and an one empty table

[DanF_(Guest)]

I have a report that includes four tables that have assigned joins on three fields. There relationship is one-to-one for all but one table and it has a one-to-many relationship. The first three tables(one-to-one) will always have data in the joined fields. The fourth table,however will not always have data in the joined fields. In most cases it will be empty. If this table is empty, the report will show "no records found". Is there a way to print the report with this fourth table empty?____Thanks__DanF__I am using Version 11, Report Works SQL version

[kfleming]

You would need to edit the join and include unmatched records on the left. This however may or may not be permitted depending on the ODBC driver that you are using.____Kathleen__R&R Support

[DanF_(Guest)]

That seems to work with my ODBC.____Thanks__DanF