Finding records that exist in one table but not in another linked tabl

[tommy19]

Howdy,

I have a little dilemma...
I need to update a field in one table that doesn't exist in another linked table. For example, There is a call back on field in a contact table, and scheduled calls in the other. There are records in the contact database that have a callbackon date but no calls scheduled. Can I access these records through an SQL query?

 

[fluteplr]

Please post the table structures and what the link is between the tables.

 

[tommy19]

There are multiple tables within the same database. ie in our contact database we have a contact history, contact1 & 2, etc, and a seperate table for the calender database,

How I usually access the data would be something like this:

select c2.accountno, c2.callbackon, cal.ondate
from cal cal, contact2 c2
where etc.

and they are linked.

I hope that this explains it well enough. If not let me know. Thank you
tommy