Oracle Subqueries

Use a subquery to populate the column, and specify the value that you want returned for a missing value (except if you have Oracle, because its Subquery processing is even worse than its set processing).

http://stackoverflow.com/a/4358687/2066936