>
>I tried a regular UNION SQL Statement, but that didn't seem right. Would this require more of a LEFT OUTER JOIN type of statement?

A left outer join would be easier to do, but theoretically an union all could also achieve what you want(in two steps). Maybe you can post your code here.