I think you may over thinking this... It is as simple as you think you
should be.... ;)
select *
from orderlines
where orderno = 'xyz123'
and status > 0
I'm assuming here that you don't have an order status with negative numbers.
Regards
Stephen
Tony Weeg wrote:
> 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.
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
