I am using the following SQL to Delete the Data in Table New_master. IF all the fields of New_master Matches With the Master.DBF the row should be deleted.

My SQL is not working, please suggest the required SQL.

MY SQL is as Follows

DELETE FROM New_Master WHERE Accountno In (Select Accountno Number FROM Master WHERE ;
New_master.Phoneno= Master.Phoneno AND New_master.Exchange= Master.Exchange AND ;
New_master.firstname= Master.firstname AND ;
New_master.lastname=ALLTRIM(Master.Lastname))

Kinldy Provide The SQL for The above Task

Regards