Using SQL Cross Join – the report writers secret weapon is a very clear explanation of the utility of cross-joins in SQL.
Cross-join = Cartesian product, something you will remember from the Topic Maps Reference Model.
Makes a robust where clause look important doesn’t it?