Delete query 1

[din2005]

Hi all,

i have two table linked delete the records that match tblnotinsheffield to tblappointments i.e

all the records in tblnotinsheffield match with tblappointments and delete it from tblappointments.

my code is this so far

DELETE tblAppointments.DiaryDate, tblAppointments.HospitalNo, tblNotInSheffield.HospitalNo
FROM tblNotInSheffield INNER JOIN tblAppointments ON tblNotInSheffield.HospitalNo = tblAppointments.HospitalNo;

but am a loss how to do the rest?

 

[KenReay]

Hi

How about:

DELETE FROM tblAppointments WHERE HospitalNo IN (SELECT tblNotInSheffield.HospitalNo
FROM tblNotInSheffield);

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK