Exception JOIN in SQL: How to Write Correctly – And Best Example

Exception JOINS are one kind of JOINS in SQL. The SQL query given in simple way gives you the actual use of it. This is an alternative to complex sub-queries. Sub-queries need lot of lines of SQL lines instead of JOINS. So JOINs are less confusing compared to Sub-queries.