[og1]

Agree with this as well. Forgot exactly what one was and googled it to make sure. The example that is used here would indicate orphaned records.

http://www.w3schools.com/sql/sql_join_right.asp

[ceejayoz]

There are valid use cases for orphaned records. A quote database might want to allow registered and anonymous submission, for example.

[derefr]

Or, ala Reddit, comments from deleted users.