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:
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?