I found what I was looking for. Rather than trying to construct the UNION query I just ran each SELECT statement in code and inserted the returned data to...

Thanks for your reply!

I kinda thought that a temp table would be a good way to go. I have not been able to find the syntax to retrieve the...