Double-check that the results are consistent with what you’d expect.

Using the LEFT JOIN produced all of the text messages, including those with and without attachments.

Using the INNER JOIN (also achieved by typing “JOIN” in the query) returned just the messages that included attachments.

RESULTS OF LEFT JOIN

(Notice how the resulting output shows messages with attachments and also those without attachments.)

RESULTS OF INNER JOIN

(Notice that the resulting messages are only those that include attachments.)