Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

The point of the simple example was to counter the statement that code would inherently become complex and unreadable if you had to track and check if the initial "WHERE 1=1" needed to be removed ...