Self joins are necessary if when showing or comparing fields from
more than one row in a table. For example, if you are showing the names of two
sales reps in the same output row, use a self join (and the necessary aliases). For example,
SELECT Lazy.xxx Busy.xxx
FROM Salesreps Lazy, Salesreps Busy, ...