Sorry John, I thought you asked about "full join" which uses no join criteria.
In the Query design window drag the column from one table to the column you want to match in the other table. Or in the SQL view just add the the comparison columns as in the following example.
SELECT tblA.Col1, tblA.Col2, tblA.Col3, tblB.ColA, tblB.ColB
FROM tblA Inner Join tblB
ON tbla.Col2=tblB.ColC;
OR
SELECT tblA.Col1, tblA.Col2, tblA.Col3, tblB.ColA, tblB.ColB
FROM tblA, tblB
WHERE tbla.Col2=tblB.ColC; Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.