Orders are taken online or by phone. I only want orders with order_type marked 'online'
I'm trying to retrieve all 'online' orders marked 'paid' or 'archived' but NOT 'open'
I tried this query but it doesn't work:
Code: Select all
"SELECT * FROM orders WHERE order_type='online' AND status='paid' OR status='archived'";All suggestions appreciated.
Thanks in advance.
mc