помогите создать запрос
u.cfd_num выдает недопустимый индентификатор?
SELECT USERS.ID,
USERS.LAST_NAME,
USERS.FIRST_NAME,
USERS.MIDDLE_NAME,
USERS.LOGIN,
USERS.POSITION,
USERS.IS_UNLOAD,
USERS.ADMIN
FROM EKON_ADMIN.USERS
WHERE
u.cad_num =:cad_num
SELECT USERS.ID,
USERS.LAST_NAME,
USERS.FIRST_NAME,
USERS.MIDDLE_NAME,
USERS.LOGIN,
USERS.POSITION,
USERS.IS_UNLOAD,
USERS.ADMIN
FROM EKON_ADMIN.USERS
WHERE
u.cad_num =:cad_num
Код:
SELECT u.ID,
u.LAST_NAME,
u.FIRST_NAME,
u.MIDDLE_NAME,
u.LOGIN,
u.POSITION,
u.IS_UNLOAD,
u.ADMIN
FROM EKON_ADMIN.USERS u
WHERE
u.cad_num = :cad_num
u.LAST_NAME,
u.FIRST_NAME,
u.MIDDLE_NAME,
u.LOGIN,
u.POSITION,
u.IS_UNLOAD,
u.ADMIN
FROM EKON_ADMIN.USERS u
WHERE
u.cad_num = :cad_num