Can I do joins in an update statement?
I can't find examples in docs anywhere...

e.g.
update table1 t1
left joint table2 t2
on t1.int_key = t2.int_key
set t1.test = 'something'
where t1.int_key = 40;

Do I go
update table -> joins -> set -> where
or
update table -> set -> joins -> where


--------------------------------------------------------
Nigel Weeks
E-Easy
15 Wellington St. Launceston Tas 7250
Ph. 61 3 6334 6664
Fax. 61 3 6331 7032
Email. nigel@...
Web: www.e-easy.com.au
--------------------------------------------------------