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.