Skip to content
Advertisement

From 2 tables, get rows unique to each table

Starting with 2 tables, I want to get all rows with value in a certain column(cName) that is present on 1 table but not the other. I want to do this for both tables. I found a solution to use LEFT JOIN which gives me solution for 1 of the tables and I used UNION to combine. Is this a good way to do this or is there a better way?

Advertisement

Answer

You can use full join with a where:

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement