On Sun, Mar 29, 2009 at 10:56 AM, Fred Jones <fredthejonester at gmail.com> wrote: > UPDATE contact > LEFT JOIN temp ON temp.contact_id = contact .id > SET xxx='yyy' > WHERE temp.contact_id IS NOT NULL; Or: UPDATE contact INNER JOIN temp ON temp.contact_id = contact .id SET xxx='yyy' -- Matt Warden Cincinnati, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy.