If I am using Union, where can I place Distinct to make sure that I don't get duplicate entries?
You don't need to. union automatically does that. If you want to get the duplicate records, then you do a "UNION ALL"
cool, eh?
