sql - APPEND SELECTED RECORDS TO TABLE -


In the SQLserver database, there are two tables EmpList and SalarySheet, I now want to transfer the "Onduty" from the EmpList table filter to the selected Records in the SalarySheet table. .

I am using the VB2010 Windows Form.

Some of the information about the layouts will be of great help to the tables, but I think it is a very common I'll take a knife.

Assume that EmpList and SalarySheet can do the following table structures:

  Select salary sheet - Include EmpList WHERE status = "Onduty" I'm just guessing that the filtering field is "status" - you'll probably need to change it to use the correct area and it can not work at all, if the payroll and amplist The fields do not exactly match  

Good luck.

Comments