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]
