SQL Question: referencing two tables in update statement

[Quoted] Hi there,

[Quoted] Quick SQL guestion:

[Quoted] How do I reference two tables in an SQL statement. What I need is something like this, but not sure about the syntax:

update table_1 ref1, table_2, ref2
set ref1.field_1 = ref2.field_1
where ref1.field_2 = ref2.field2;

Any help would be VERY MUCH appreciated.

Thanks,

Stuart

-- 
Stuart Chaulk - Project Logistician
Community Health Resource Project
University of British Columbia | Centre for Excellence in HIV/AIDS
schaulk_at_hivnet.ubc.ca | http://cfeweb.hivnet.ubc.ca/chrp/