The SQL MINUS query returns all rows in the first SQL SELECT statement that are not returned in the second SQL SELECT statement. Each SQL SELECT statement within the SQL MINUS query must have the same number of fields in the result sets with similar data types.
The syntax for the SQL MINUS query is:
select field1, field2, ... field_n
But this query is not implemented in MySQL. So to achieve the same effect you can use the following Query statement.
select field1, field2, ..., field_n
where (field_x) NOT IN (select field_x from table2);
Where field_x is the field over which the comparison is performed.