OUTER JOIN

[Jamie]

I have four tables that DO NOT share information, but DO
share the same field names. I need to create a report
that draws information from all four tables during a
certain period of time. I can not find the syntax in SQL
to make it happen. ANY IDEAS??? I do not want to use a
UNION- since none of the tables have a relationship other
than the same field names.

 

[Roger Carlson]

Since the data in each table has no relationship to the data in any other
table, you can't Join them. I'd just create four separate reports, then
place them on a 5th report as sub-reports.

 

[Bas Cost Budde]

I have four tables that DO NOT share information, but DO
share the same field names. I need to create a report
that draws information from all four tables during a
certain period of time. I can not find the syntax in SQL
to make it happen. ANY IDEAS??? I do not want to use a
UNION- since none of the tables have a relationship other
than the same field names.

You can UNION them (not JOIN), effectively creating a grand table with
all records.