Queries on 20 tables

[jappianing]

Hello Brethren,
I seiously l need your help urgently. I'm trying to run a query on 20 unrelated tables. Some of the tables are related. I used the query wizard but the wizard returned empty fields. I tried to manipulate the SQL code using RIGHT JOIN, LEFT JOIN OR OUTER JOIN, but to no avail.
Your suggestions will be very much appreciated.
joe

 

[GSSDevelopment]

If the tables must be unrelated, then you can use the Query Designer to bring in the tables you need, the fields you want, then click-and-drag the fields from the tables to make the join criteria. That usually works better for me than trying to create the query manually.

I just did the same thing with an insurance rating system

 

[jappianing]

Thank you very much for your quick response. I will try it tomorrow. I'm almost done for the day.

 

[GSSDevelopment]

Any luck or update on this?