RE: [DUG]: joining in update query

[James Low]

Title: Normal

Think you may have missed the select operator and some brackets ??     update TABLE1 set 1.updatefield = (Select 3.updatefield FROM TABLE1 1, TABLE2 2, TABLE3 3 Where 1.idfield = 2.idfield and 2.anotheridfield = 3.anotheridfield)   James Low       -----Original Message----- From: Tracey Maule [mailto:[EMAIL PROTECTED] Sent: Wednesday, 6 August 2003 11:56 AM To: Multiple recipients of list delphi Subject: [DUG]: joining in update query   Hi guys   how do i do this in interbase??   update TABLE1 set 1.updatefield = (Select 3.updatefield FROM TABLE1 1, TABLE2 2, TABLE3 3 Where 1.idfield = 2.idfield and 2.anotheridfield = 3.anotheridfield)     Tracey Software Developer / Web Master Logis [EMAIL PROTECTED] (025) 213-1065 This e-mail message has been swept for content and viruses. No viruses were detected. Contact the Helpdesk on extension 9CIS (9247) for assistance, if required. Email disclaimer: This email and any attachments are confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way.  If you receive this message in error, please let us know by return email and then destroy the message. Environment Bay of Plenty is not responsible for any changes made to this message and/or any attachments after sending. This e-mail has been checked for viruses and no viruses were detected.