SELECT *
FROM table
WHERE status = 1
AND orderid NOT IN (select orderid from table where status = 0)
----- Original Message -----
From: "Tony Weeg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, July 23, 2004 8:30 AM
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]
