GATE question

Question

To retrieve rows which do not satisfy a query which join is used in sql?

Answer 1

You can complement the join condition.
You can also use Outer join to get the rows that satisfy the condition as well as the rows that does not satisfy the join condition.
The result ,you get perform set difference to the query of join condition. the final result returns rows that does not satisfy the join condition.