Trying to perform MINUS operation in MySQL

MySql does not recognise MINUS and INTERSECT, these are Oracle based operations. In MySql a user can use NOT IN as MINUS (other solutions are also there, but I liked it lot). Example:

from table1 as a 
where <condition> 
AND NOT IN (select 
                 from table2 as b 
                 where <condition>);

Leave a Comment