Perfect Sandeep! Thank you so much!
Shehap, I gave it a try and it did not work. I got this error: Column 'BarCollectionTransactions.BatchDateTime' is invalid in the select list...
I have two select statements that execute the way I expected them to execute. Now what I need is to put the two together without InsuranceID column...
Separate names with a comma.