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
This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.