SmpTraining
MIS
I am trying to update a field in one table with a value from another table and don't know the syntax.
Table1: PEOPLE
Table2: DATA_IMPORT
tables link on NI_Number field
Want to copy Data_Import.Status field into People.Status field where the NI numbers match.
Can anyone help please? Steve Phillips, Crystal Consultant
Table1: PEOPLE
Table2: DATA_IMPORT
tables link on NI_Number field
Want to copy Data_Import.Status field into People.Status field where the NI numbers match.
Can anyone help please? Steve Phillips, Crystal Consultant