(select ordereid from table where status = 0)
Is the absolute first thing that comes to mind. I'm sure some better and
more efficient ideas will come through though.
Ken Ferguson
Fitz and Floyd
http://www.fitzandfloyd.com
http://www.exclusivelyfitz.com <http://www.exclusivelyfitz.com/>
http://stores.ebay.com/fitzandfloydscharmingtails
_____
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Friday, July 23, 2004 8:31 AM
To: CF-Talk
Subject: sql question
sql gurus...got a question.
lets say i have a table, and in that table there could be 2 rows for
one order coming from crm system.. the first row, has a status of 1,
meaning new, and process it now. the second row, would match on a
order number column, but a status of 0...meaning cancelled. i want to
show all rows from the table that dont have a matching 0 status row.
is this possible in 1 query?
something like this..
select *
from table
where status = 1 and status <> 0
:) i know this is way off, but im not sure how to compare, where i
have a matching column, but an opposing status of 0 with the same
order id.
thanks :)
--
tony
Tony Weeg
human.
email: tonyweeg [at] gmail [dot] com
blog: http://www.revolutionwebdesign.com/blog/
Check out http://www.antiwrap.com to send websites to your friends.
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
