>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
You can use delete from syntax here, e.g.
delete NM from New_Master NM inner join Master M on NM.PhoneNo = M.PhoneNo and ...
If it's not broken, fix it until it is.
My Blog