HI,

I'm sure this must be simple but I just can't get the syntax right.

sql="select * FROM products INNER JOIN (orderitems INNER JOIN orders ON orders.orderid=orderitems.orderid) ON products.productid=orderitems.productid where ostatus<>'Cancelled' and custid=" & valid_sql(session("custid")) & " order by orders.orderid"

That works OK but I want ostatus<>'Cancelled OR 'Uncompleted'

Anyone?

you can do this in a few different ways.

1: ostatus<>'Cancelled' OR ostatus<> 'Uncompleted'
2: ostatus not in ('Cancelled', 'Uncompleted')

HTH

Thanks

Method 1 doesn't work, I had tried that it just goes into a loop.
Method 2 works fine though.

to get 1 to work....
should be
status must not = Cancelled and Status must not = Uncompleted. if it is or then the Cancelled's <> Uncompleted so they pass and visa versa.

Thanks rokslide...that was my bad.

Thats not correct, there are no records that are both cancelled and uncompleted, they are either one or the other, or something else. If I use that it returns all records.

using the above should return those that are (as you put it) "something else". If it is returning everything then I would be tempted to suggest that there is a flaw somewhere else in your query. It's possible that you need to wrap this section in brackets or something else, it really depends on what is happening...