unrelated tables

[princessinthetower]

I want to report on rows in several tables that have been updated within a specified date range. Except for each table having an update date, the tables are unrelated. How can I select address, job, and other tables that may have an ID in common but don't necessarily?

 

[synapsevampire]

Use a Union Query.

This depends upon technical information, such as Crystal version, database and connectivity, etc., which you didn't to post.

An example would be if you had 3 tables with similar data elements to be extracted, but they couldn't be joined:

Create a report using Table1

Then select Database->Show SQL Qeury

Copy the SQL

Skip to a line after the SQL and type the word UNION

Paste in the SQL

Modify it to reflect the table2 names

Do the same for table 3

Now you'll get all 3 sets of data as one regardless of whether they can be linked.

-k