Entry

How can I UPDATE table set field=value where field2 in (select field3 from other_table)?

Feb 24th, 2008 00:18
dman, Euan MacInnes, Darryl Plunkie, http://www.ttnr.org

The hard way by doing the select field3 from other_table first, 
storing the result in a local variable, comma separated, and then 
running a second query