[thelist] SQL Joins

Bill Haenel bill at webmarketingworx.com
Tue May 21 15:36:00 CDT 2002


Here's my problem...

I have 2 tables: table1 and table2

table1 has three fields: one_id, one_name, two_id

table2 has two fields: two_id, two_name

I want to select table1.one_name where table1.two_id matches any of the
table2.two_id's where table2.two_name != 'George'.

I have a feeling I'm nuts. Am I? If not, how would I do it?

Thanks a mil.

BH




More information about the thelist mailing list