OUTER JOIN

  • Thread starter Thread starter Jamie
  • Start date Start date
J

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.
 
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.
 
Jamie said:
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.
Click to expand...

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