Testing, I know there are 4 records I want returned. I am getting 3. The 3 that have optional link information (an entry in the video_links table).

SQL queries are written in an English-like syntax. Imagine a magazine publisher which keeps a list of subscribers in a database table, sorted by first name, last name, address, subscription ...