MySQL MINUS Alternative Using LEFT JOIN

1 year ago
William Carter
1 minute

In MySQL, there is no built-in MINUS function, but similar functionality can be achieved by using a LEFT JOIN and WHERE clause. For example, to find different records in two tables, you can use the following statement:

SELECT table1.column1, table1.column2
FROM table1
LEFT JOIN table2 ON table1.column1 = table2.column1
WHERE table2.column1 IS NULL;

This statement will return records that exist in table1 but do not exist in table2. Therefore, even though MySQL does not have a MINUS function, similar functionality can be achieved using LEFT JOIN and WHERE clause.

bannerAds