Delete NM From New_Master NM inner join Master M on VAL(NM.Accountno)=M.Accountno AND ; ALLTRIM(NM.PhoneNo)=ALLTRIM(M.PhoneNo) and ; ALLTRIM(NM.Exchange)=ALLTRIM(M.Exchange) AND ALLTRIM(NM.Firstname)=ALLTRIM(M.Firstname) AND ; ALLTRIM(NM.Lastname)=ALLTRIM(M.LastName)>>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.
>>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)) >>>>
>delete NM from New_Master NM inner join Master M on NM.PhoneNo = M.PhoneNo and ...