Subject | Re: [firebird-support] does firebird support this update syntax |
---|---|
Author | Ivan Prenosil |
Post date | 2005-07-11T18:43:08Z |
> Does Firebird 1.5 support the following syntax for update queries?No.
Ivan
>
> Thanks,
>
> Fr. Robert
>
> UPDATE
> TBL_EMPLOYEES
> SET
> (TBL_EMPLOYEES.ENTERPRISE_ID,TBL_EMPLOYEES.LOCATION_ID,TBL_EMPLOYEES.COMPANY
> _EMPLOYEE_ID,TBL_EMPLOYEES.LAST_NAME,TBL_EMPLOYEES.FIRST_NAME,TBL_EMPLOYEES.
> MIDDLE_NAME,TBL_EMPLOYEES.NICK_NAME,TBL_EMPLOYEES.POSITION,TBL_EMPLOYEES.ACT
> IVE1,TBL_EMPLOYEES.SUPERVISOR,TBL_EMPLOYEES.EMPLOYEES_SUPERVISOR,TBL_EMPLOYE
> ES.SSN,TBL_EMPLOYEES.ADDRRESS1,TBL_EMPLOYEES.ADDRESS2,TBL_EMPLOYEES.CITY,TBL
> _EMPLOYEES.STATE,TBL_EMPLOYEES.ZIP,TBL_EMPLOYEES.COUNTY,TBL_EMPLOYEES.HOME_P
> HONE,TBL_EMPLOYEES.WORK_PHONE,TBL_EMPLOYEES.PAGER,TBL_EMPLOYEES.CELL_PHONE,T
> BL_EMPLOYEES.FAX,TBL_EMPLOYEES.EXTENSION,TBL_EMPLOYEES.EMAIL,TBL_EMPLOYEES.C
> ONTACT_INFO,TBL_EMPLOYEES.EMP_PICTURE,TBL_EMPLOYEES.CASE_MANAGER,TBL_EMPLOYE
> ES.CM_NUMBER,TBL_EMPLOYEES.SERVICE_COORDINATOR,TBL_EMPLOYEES.PROGRAM_CONRACT
> )
> =
> (SELECT
> TBL_EMPLOYEES_IMPORT.ENTERPRISE_ID,TBL_EMPLOYEES_IMPORT.LOCATION_ID,TBL_EMPL
> OYEES_IMPORT.COMPANY_EMPLOYEE_ID,TBL_EMPLOYEES_IMPORT.LAST_NAME,TBL_EMPLOYEE
> S_IMPORT.FIRST_NAME,TBL_EMPLOYEES_IMPORT.MIDDLE_NAME,TBL_EMPLOYEES_IMPORT.NI
> CK_NAME,TBL_EMPLOYEES_IMPORT.POSITION,TBL_EMPLOYEES_IMPORT.ACTIVE1,TBL_EMPLO
> YEES_IMPORT.SUPERVISOR,TBL_EMPLOYEES_IMPORT.EMPLOYEES_SUPERVISOR,TBL_EMPLOYE
> ES_IMPORT.SSN,TBL_EMPLOYEES_IMPORT.ADDRRESS1,TBL_EMPLOYEES_IMPORT.ADDRESS2,T
> BL_EMPLOYEES_IMPORT.CITY,TBL_EMPLOYEES_IMPORT.STATE,TBL_EMPLOYEES_IMPORT.ZIP
> ,TBL_EMPLOYEES_IMPORT.COUNTY,TBL_EMPLOYEES_IMPORT.HOME_PHONE,TBL_EMPLOYEES_I
> MPORT.WORK_PHONE,TBL_EMPLOYEES_IMPORT.PAGER,TBL_EMPLOYEES_IMPORT.CELL_PHONE,
> TBL_EMPLOYEES_IMPORT.FAX,TBL_EMPLOYEES_IMPORT.EXTENSION,TBL_EMPLOYEES_IMPORT
> .EMAIL,TBL_EMPLOYEES_IMPORT.CONTACT_INFO,TBL_EMPLOYEES_IMPORT.EMP_PICTURE,TB
> L_EMPLOYEES_IMPORT.CASE_MANAGER,TBL_EMPLOYEES_IMPORT.CM_NUMBER,TBL_EMPLOYEES
> _IMPORT.SERVICE_COORDINATOR,TBL_EMPLOYEES_IMPORT.PROGRAM_CONRACT
> FROM TBL_EMPLOYEES_IMPORT
> WHERE
> TBL_EMPLOYEES_IMPORT.EMPLOYEE_ID = TBL_EMPLOYEES.EMPLOYEE_ID)