Hello.
I have a one table that contains pay type records for all of my employees. I would like to add one pay type to every employee but am not sure how.
I tried this:
INSERT INTO premppay (prep_emp, prep_pay) VALUES (6569, 759)
but that only inserts the record into one employee (ee# 6569).
How would I add pay type 759 to all employees.
I thought about this:
INSERT INTO premppay (prep_pay) VALUES (759)
but am leery of trying this until I get some more feedback.
Thanks in advance.
I have a one table that contains pay type records for all of my employees. I would like to add one pay type to every employee but am not sure how.
I tried this:
INSERT INTO premppay (prep_emp, prep_pay) VALUES (6569, 759)
but that only inserts the record into one employee (ee# 6569).
How would I add pay type 759 to all employees.
I thought about this:
INSERT INTO premppay (prep_pay) VALUES (759)
but am leery of trying this until I get some more feedback.
Thanks in advance.