3810: Column / Parameter 'EDW_STAGE.F4.CLIENTE_ID' does not exist

Database
Enthusiast

3810: Column / Parameter 'EDW_STAGE.F4.CLIENTE_ID' does not exist

Trying to run this query I get the customer_id column does not exist and still do not understand why they should join me to bring the data for this column.

Thank you in advance for your attention.

 SELECT
DISTINCT
CAST(F4.CLIENTE_ID AS INTEGER) CLIENTE_USUARIO_IPS_ID
,TEMP.CODIGO_CLIENTE_USUARIO_IPS_OP
,F4.TIPO_IDENTIFICACION_CD TIPO_IDENTIFICACION_CD
FROM EDW_STAGE.PE710_AGNOVC TEMP

INNER JOIN EDW_STAGE.PE710_TT F4
ON (F4.EXT_IDENTIFICATION_NUM = TEMP.CODIGO_CLIENTE_USUARIO_IPS_OP
AND 25 = F4.EXT_IDENTIFICATION_TYPE_CD)

Tags (1)
1 REPLY
Enthusiast

Re: 3810: Column / Parameter 'EDW_STAGE.F4.CLIENTE_ID' does not exist

The problem really if it was the name of the field if it was incorrect, the correct name was party_id and customer_id, this can be given by post solved.