select * from mytable
where status <> 0
will automatically remove all the items with 0 as the status... where
status = 1 will get you all the items with status 1, and so will also
disclude status 0 (and any other non-1 status)...
> 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]
