I have two views with an ID and an id_code field. (The underlying table is the same.) How can I select all the ID's from view 1 that are not present in view two?
The following code returns the ID's if it exists, but the opposite returns no data. I know that there is data that is in view 1 but not view 2.
(select AN_ID from
(Please forgive double posting if it happens...I can't see the 1st post)
Click Here to Expand Forum to Full Width