How to get unmatched records from two tables in SQL?

Question

Can anyone explain how to get unmatched records from two tables in SQL?

Answer 1

‘IN’ operator can be used to get the unmatched records from two tables in SQL and the following query is for that:

SELECT TableA.id

FROM TableA

WHERE TableA.id NOT IN (

                                                   SELECT TableB.id

                                                  FROM TableB

                                                  )

If you want to learn SQL from top experts, you can check out this SQL Training course by Intellipaat.