Hello Guys,I have two tables First One is. tblSalaryMaster(salaryID,salaryName)records are 1 Basic, 2 HRA, 3 Caand 2nd is tblSalaryDetailMaster(companyID,employeeID,salaryID,salaryAmount)records are 1 1 1 100001 1 2 40001 1 3 30001 2 1 150001 2 2 70001 2 3 2000and so onnow i add one more record to First Table 4 Allowanceas i am updating the second table now i want to compare first table valueswith second table and if second table don't have the record(salaryID) then insert the record intosecond table.Please help me.