> UPDATE contact > INNER JOIN temp ON temp.contact_id = contact .id > SET xxx='yyy' Show off ;) Seriously, that's the same? I never really can remember anything but LEFT join. :(