Have Geek Brain

How to get unmatched records using SQL query?

Actually, if I do an INNER JOIN from two tables, then I will get all mapped records from two tables. But I only want to get all non-comparable strings.

Is there a way to do this? Or any access available for this?

+2


a source to share


1 answer


There is a connection you can use. You only need OUTER JOIN

and select the lines with NULL

in the join condition.



Another option is to use a sub-request with NOT EXISTS

or NOT IN

as part of your main proposal WHERE

.

+3


a source






More articles:


All Articles