AnsweredAssumed Answered

Complex Update Query in SQL

Question asked by suhail-sayed Champion on Nov 15, 2016
Latest reply on Nov 21, 2016 by Tim1302647

Hello there,


I am developing an Update query in SQL whereby the Booking Managers will be directly updated from the LDAP directory and replace the old values. So, I need the correct Update query syntax for this please. For example:


update A

set A.fieldname = B.fieldname

where B. fieldname = C.fieldname


and something similar with a few DB Tables. So, is it possible to insert a FROM or a JOIN clause within this Update query just before the WHERE clause?