Hi again, RTFM >Some Googling led to: >UPDATE Protocols SET pr_RespDepartment=re_de_PK FROM >(Protocols as Prots LEFT JOIN Responsables on re_pr_PK=Prots.pr_PK) WHERE re_Responsible=true;
Must be: UPDATE Protocols SET pr_RespDepartment=re_de_PK FROM Responsables WHERE re_Responsable=true and re_pr_PK=pr_PK; No need to use JOIN and everything updated nicely as if a join was made. Should have read the manual earlier... Marc ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/2jUsvC/tzNLAA/TtwFAA/HKFolB/TM --------------------------------------------------------------------~-> Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
