Hi,

I don't think a UNION will work because the result will essentially append the second query to that of the first. What I really want is the first query with additional information from the second all in one record.

Thanks for the suggestion.