Results 1 to 2 of 2
Thread: Join Update
Jan 19, 2005, 12:26 #1
- Join Date
- Feb 2004
- St. Paul
- 0 Post(s)
- 0 Thread(s)
I have 3 tables (employees, spouses, children) and I want to use one table (employees) to update the other 2. This is a one time query and I want the addresses of the spouses and children to match the employees.
How would I write an update statement to do that (using ColdFusion and SQL Server 2000)?
Thanks for your help.
Jan 20, 2005, 01:51 #2
You can not do this in one query.
You can only update one table at a time.
You would have to write a stored procedure.