B
Bob
running access 2k;
I have 2 queries - BOTH should work as far as I can see, and NEITHER
does; each reporting "could not delete from specified table".
Obviously, they are 2 attempts to complete the same deletion task,
which is to delete every record found in the ZQ_delete-dups recordset
from the Q_patients recordset.
Sounds simple, looks simple, s/b simple, but apparently it's not. I
believe either of these would work under sql-server....
Here's the first query:
DELETE Q_patients.*
FROM Q_patients
WHERE (((Q_patients.T_contacts.contact_id) In (select
ZQ_delete_dups.contact_id from ZQ_delete_dups)));
Here's the 2nd query:
DELETE Q_patients.*
FROM Q_patients RIGHT JOIN ZQ_delete_dups ON
Q_patients.T_contacts.contact_id = ZQ_delete_dups.contact_id;
TIA- Bob
I have 2 queries - BOTH should work as far as I can see, and NEITHER
does; each reporting "could not delete from specified table".
Obviously, they are 2 attempts to complete the same deletion task,
which is to delete every record found in the ZQ_delete-dups recordset
from the Q_patients recordset.
Sounds simple, looks simple, s/b simple, but apparently it's not. I
believe either of these would work under sql-server....
Here's the first query:
DELETE Q_patients.*
FROM Q_patients
WHERE (((Q_patients.T_contacts.contact_id) In (select
ZQ_delete_dups.contact_id from ZQ_delete_dups)));
Here's the 2nd query:
DELETE Q_patients.*
FROM Q_patients RIGHT JOIN ZQ_delete_dups ON
Q_patients.T_contacts.contact_id = ZQ_delete_dups.contact_id;
TIA- Bob