Let’s say that I have a database (and, by coincidence, I do!) of cartoons,linked to a table of the DVDs they appear in, and that linked to the people who do the commentaries on each cartoon for that DVD.
So, if I do a query for that DVD, the cartoons and the commentators, it might return something like this:
DVD Title Commentators
-----------------------------------------------------------------------------------------
The Simpsons Season 10 Lard of the Dance Mike Scully
The Simpsons Season 10 Lard of the Dance Ron Hague
The Simpsons Season 10 Bart the Mother Matt Groening
The Simpsons Season 10 Bart the Mother Mike Scully
The Simpsons Season 10 Bart the Mother George Meyer
But now, lets say that I had a cartoon that didn’t have any commentators. The SQL doesn’t return anything since there’s nothing to link it to at the end. Is there anyway to have the SQL return at least one entry, even if the last one has a null value for the commentator?
Like this:
DVD Title Commentators
-----------------------------------------------------------------------------------------
The Simpsons Season 10 Lard of the Dance Mike Scully
The Simpsons Season 10 Lard of the Dance Ron Hague
The Simpsons Season 10 Bart the Mother Matt Groening
The Simpsons Season 10 Bart the Mother Mike Scully
The Simpsons Season 10 Bart the Mother George Meyer
The Simpsons Season 10 Lisa gets an A NULL