Native SQL(Snowflake) Issue - Column ambiquous Issue

[Dinvae]

Hi Experts,

Appreciate any quick help

Below sql throws error in expression i think same column name ambiquous 

Expression.Error: The field 'STATUS' already exists in the record

Details:

 Name=STATUS

 Value=

SELECT

BDE.ORDER_STATUS.STATUS,

,

BDE.SMT.STATUS

FROM

QA_DF.BDE.SM_NODE RIGHT OUTER JOIN QA_DF.BDE.ORDER_LINE ON (QA_DF.BDE.SMT_LINE.ORDER_LINE_KEY=QA_DF.BDE.ORDER_LINE.ORDER_LINE_KEY)

INNER JOIN QA_DF.BDE.ORDER_REL_STATUS ON (BDE.ORDER_LINE.ORDER_LINE_KEY=BDE.ORDER_STATUS.ORDER_LINE_KEY)

WHERE

(

BDE.ORDER_STATUS.STATUS

= '1000'

)

[v-yanjiang-msft]

Hi @Dinvae ,

Not sure why based on the query, I suggest you modify the sql query to:

SELECT
*
FROM
QA_DF.BDE.SM_NODE RIGHT OUTER JOIN QA_DF.BDE.ORDER_LINE ON (QA_DF.BDE.SMT_LINE.ORDER_LINE_KEY=QA_DF.BDE.ORDER_LINE.ORDER_LINE_KEY)

INNER JOIN QA_DF.BDE.ORDER_REL_STATUS ON (BDE.ORDER_LINE.ORDER_LINE_KEY=BDE.ORDER_STATUS.ORDER_LINE_KEY)

Then see if columns "BDE.ORDER_STATUS.STATUS" and "BDE.SMT.STATUS" are contained in the result.

Best regards,

Community Support Team_yanjiang