[DUG]: joining in update query

[Tracey Maule]

Hi guys   how do i do this in interbase??   update TABLE1 set 1.updatefield = 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