I am trying to query two SQl 2000 tables and find out which value is not in a particular table.
The first table is called docsadm.people and contains columns named full_name and system_id
The second table is called docsadm.profile and contains columns named typist and author.
The docsadm.profile.typist and docsadm.profile.author columns have numeric values and reflect the values listed in the docsadm.people.system_id column.
I am trying to write a query that will tell me which docsadm.profile.typist and docsadm.profile.author value is not listed in the docsadm.people.system_id column.
Thanks for your assistance. Frank -