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
Navigation:
[Reply to this message]
|