[thelist] SQL Joins

[Plunkett, Matt]

maybe?

select table1.one_name
from table1, table2
where table1.two_id = table2.two_id
and table2.two_name <> 'George'

	-----Original Message-----
	From:	Bill Haenel [SMTP:bill at webmarketingworx.com]
	Sent:	Thursday, May 16, 2002 4:35 PM
	To:	thelist at lists.evolt.org
	Subject:	[thelist] SQL Joins

	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

	--
	For unsubscribe and other options, including
	the Tip Harvester and archive of thelist go to:
	http://lists.evolt.org Workers of the Web, evolt !