Posted by Stu on 01/02/06 06:41

This can be solved using a standard inner JOIN:

SELECT t1.*, t2.*
FROM Table1 t1 JOIN Table2 t2 ON t1.ColumnA = t2.ColumnB

Since you're asking the question, it's obvious that you are probably
new to SQL. Newsgroup posters can be harsh teachers; I'd suggest that
you pick up a couple of books on basic SQL. I like Ben Forte's 10
Minute Guide to SQL as a basic primer.

HTH,
Stu

[Back to original message]