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
Harsh