Once query to lookup information in multiple tables

[Yanagowa]

Hi All,

I have a number of tables and I want to use a query to extract the information (Lookup specific dates) so that I can generate a single report. I have managed to get it correct on 1 table however my ulitmate goal is to generate 1 report from information contatained in 4 different tables. I must stress that the information contained within each table is total independant and has no common area except the date, I want to present this info in seperate sections in 1 report. Am I going about it the right way? Any help greatly appreciated



Thanks

[Brenda1636]

Your query should use a JOIN.

SELECT *
FROM table 1 INNER JOIN table2 ON table1.date = table2.date;

This will return all the information in both tables where the date in table1 is the same as the date in table2.

Brenda