Here's one approach:
SELECT *
FROM table t1
WHERE status = 1
AND NOT EXISTS (
SELECT 1
FROM table t2
WHERE t2.status = 0
AND t1.orderNumber = t2.orderNumber
)
-joe
----- Original Message -----
From: Tony Weeg <[EMAIL PROTECTED]>
Date: Fri, 23 Jul 2004 09:30:32 -0400
Subject: sql question
To: CF-Talk <[EMAIL PROTECTED]>
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]
