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.
CAST(F4.CLIENTE_ID AS INTEGER) CLIENTE_USUARIO_IPS_ID
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)
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.