I have been using subqueries in Where clauses since I learned TSQL. This SQL below gives me all of the data in one table that is not in another table. Clemons, try doing that with XML! <g>
select location_id from rpt_rcep11 where location_ID not in (select location_ID from dbo.tblExtrnl_Location_Mapping group by location_ID) group by location_id
Page rendered at Tuesday, December 6, 2022 11:06:13 PM (Eastern Standard Time, UTC-05:00)
The opinions expressed herein are my own personal opinions and do not represent
my employer's view in anyway.