UPDATE emp1 SET teamid = '11' WHERE empid = '1'
UPDATE emp1 SET teamid = '13' WHERE empid = '1'
UPDATE teams1 SET teamid = ‘12’ WHERE teamid = ‘4’
UPDATE teams1 SET teamid = ‘1’ WHERE teamid = ‘12’


INSERT INTO teams1 VALUES ('14','TEST',’5')
INSERT INTO teams1 VALUES ('15','TEST',’4')
INSERT INTO teams1 VALUES ('15','TEST',’5')



INSERT INTO emp1 VALUES ('42','M','1965-11-06 00:00:00','Tester1',’13’)
INSERT INTO emp1 VALUES ('43','M','1965-11-06 00:00:00','Tester2',null)
INSERT INTO emp1 VALUES ('44','M','1965-11-06 00:00:00','Tester3',’22’)