Isn't this a lot more work both for the user and the RDBMS than just using a relatively simple left join?