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.