I want to compare two tables and display items from one table that are not in the other table. The query returns no results as written below. Thanks.
select distinct STATE_lookup.STATE, state_fullname from STEO.ADOPT_STATE, STEO.STATE_LOOKUP
where STATE_LOOKUP.STATE NOT IN (select STATE from adopt_state)
and state_lookup.state <> 'DC'
and state_lookup.state <> 'US'
order by state_fullname
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.