An OUTER join really does not apply to an application like TSM.  There is a
right, left and plain.  An OUTER basically keeps the left or right select
(or both) and joins what it can with the items that do not match having null
results.