outer join/enriching data

[Michael Brill]

Assume that I have an initial table and I want to add fields to it by joining to another table.  However, the second table does not include data for all of the rows in the first table, so a join will strip some of the rows from the first table out.  The behavior I want is to keep all of the rows in the first table and then just have values for the new fields where they exist... and they can be null if they don't exist.

Is there any way to do this without using a UDF (that would basically operate as a correlated subquery - except it would be in Javascript which we're trying to avoid)?  

[shimonchayim]

Not without udf at this time.