Full outer join not working, got a multi-part identifier could not be bound error

Question

I am doing a full outer join of two tables, but received the multi-part identifier could not be bound error. I couldn't figure out why as I have checked everything else.

SELECT      A.INTEGRATION_ID,
            A.CURR_STG_NAME,
            B.CURR_STG_NAME
    
FROM        OPTY0430 AS A
FULL OUTER JOIN OPTY0507 AS B
ON OPTY0430.INTEGRATION_ID=OPTY0507.INTEGRATION_ID

I can not use inner join or cross join. I have to use full outer join to achieve what I am trying to do

Do the close voters believe "OPTY0430" is a typo for "A"? – George Menoutis May 14 '23 at 20:25 — George Menoutis, May 14 '23 at 20:25

score 1 · Accepted Answer · answered May 12 '23 at 16:49

Since you declared alias A and B for tables you need to use those in join your condition instead of actual table names.

SELECT      A.INTEGRATION_ID,
            A.CURR_STG_NAME,
            B.CURR_STG_NAME
    
FROM        OPTY0430 AS A
FULL OUTER JOIN OPTY0507 AS B
ON A.INTEGRATION_ID=B.INTEGRATION_ID

Full outer join not working, got a multi-part identifier could not be bound error

1 Answers1