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?

 

Thanks,

 

Suhail.

Outcomes