i have sql query , wish retrieve data set:
select reference, deliverydate, secondarydate, purchaseid, itemdescription, status playbook (supplier='play') , (status = '0') order deliverydate desc; however wish exclude dataset retrieved below first query:
select reference, deliverydate, secondarydate, purchaseid, itemdescription, status playbook (supplier = 'play') , (status = '0') , (tax = 'yes') , (problem = 'damaged');
use this, if want take care of order also. else use except
select * ( select reference, deliverydate, secondarydate, purchaseid, itemdescription, status playbook (supplier='play') , (status = '0') except select reference, deliverydate, secondarydate, purchaseid, itemdescription, status playbook (supplier='play') , (status = '0') , (tax = 'yes') , (problem = 'damaged') ) t1 order deliverydate desc 