select user_id,partner_order_id from pharmeasy_status where status!="CANCELLED" or status!="DELIVERED"'
is this querry right?
Loading
select user_id,partner_order_id from pharmeasy_status where status!="CANCELLED" or status!="DELIVERED"'
is this querry right?
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Rajanikant HawaldarPosted Jul 26, 2022, 9:31 AM
Try,
select user_id,partner_order_id from pharmeasy_status where status NOT IN("CANCELLED","DELIVERED")
Sudha ShankarPosted Jul 26, 2022, 9:03 AM
Sachin SinghPosted Jul 26, 2022, 8:40 AM