Thank you all for the assistance. I think ultimately using the UNION ALL method was the trick, will report back once final results are in.