O'Reilly logo
  • Bipin Hattiangadi thinks this is interesting:

If you do not specify the type of join, then the server will do an inner join by default. As you will see later in the book, however, there are several types of joins, so you should get in the habit of specifying the exact type of join that you require.

From

Cover of Learning SQL, 2nd Edition

Note

*