But think the best option so far might be the NOT LIKE suggtion by Mark.
Thanks for this option also, need to play with all of them and see what I
get.
This DB is just sooo screwed up, that its turning my brain to mush.
Thanks for all the help from everyone.
-----Original Message-----
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 09, 2004 10:08 AM
To: CF-Talk
Subject: RE: SQL Help
My first suggestion would be an embed sub-query.
SELECT
fields
FROM
Table.
( SELECT
fields
FROM
TABLE
WHERE
Name LIKE "%Engineering%"
) AS FooBar
WHERE
FooBar.ID = Table.ID
AND Name LIKE "%Open%"
Of course this assumes you are using a DBMS that allows sub-queries. I
understand that not all of them do.
--------------
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
"C code. C code run. Run code run. Please!"
- Cynthia Dunning
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
