Subject | does firebird support this update syntax |
---|---|
Author | Robert Bower |
Post date | 2005-07-11T15:09:44Z |
Does Firebird 1.5 support the following syntax for update queries?
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)
[Non-text portions of this message have been removed]
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)
[Non-text portions of this message have been removed]