Link Data From Multiple Tables 1

[TimTDP]

I am a newbie!

I have two tables.
How do I join them in an sql statement so that I can use the data in a report?

 

[Andrzejek]

You need to know how the 2 tables relate, which field is the Key, (let's say it is SSN) so you can:

SELECT Table1.*, Table2.* 
FROM Table1, Table2
WHERE Table1.SSN = Table2.SSN
ORDER BY Table1.SomeField

Have fun.

---- Andy