how can update (insert) the employees table column joindate with the info table column joindate ? I want to insert (update) info table joindate into employees table. insert all joindate into employees joindate where employees.empno=info.empno
update employees set joindate = from info where employees.empno=info.empno and joindate is null
well, with out more info there's not really much to say. post the create table, insert into (sample data), and desired results so we can test it on our machines and give the answer.
Go with the flow & have fun! Else fight the flow :)
update query
Forum Locked
Posted - 08/24/2004 : 03:21:47
