I think your last statement is the best way. You can also try
SELECT A.*
from A left join B on
A.x = B.y
where B.y is null
More Related Contents:
- MySQL Join Where Not Exists
- What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
- How can I do three table JOINs in an UPDATE query?
- 1052: Column ‘id’ in field list is ambiguous
- Join tables with SUM issue in MYSQL
- MySQL: Quick breakdown of the types of joins [duplicate]
- MySQL update table based on another tables value
- Required to join 2 tables with their FKs in a 3rd table
- MySQL join with where clause
- How can I join multiple SQL tables using the IDs?
- JOIN queries vs multiple queries
- Why does MySQL report a syntax error on FULL OUTER JOIN?
- conditional join in mysql
- MYSQL Select MAX Date inside a join statement
- CROSS/OUTER APPLY in MySQL
- Mixing ANSI 1992 JOINs and COMMAs in a query
- a count for each join – optimisation
- Combine Multiple child rows into one row MYSQL
- Cumulative sum over a set of rows in mysql
- MySql Count cannot show 0 values
- What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
- MySQL update a joined table
- MySQL JOIN with LIMIT 1 on joined table
- Laravel join with 3 Tables
- MySQL Insert & Joins
- mySQL – Create a New Table Using Data and Columns from Three Tables
- Count with IF condition in MySQL query
- How to join two tables using a comma-separated-list in the join field
- MySQL how to join tables on two fields
- When to use a left outer join?