I am having difficulty with the following query. I am at a client site and do not have admin priv.
I need to do two outer joins to get the non matching values from the tables. My base table is IV_BA_ETL_STAGE2 , and I have to verify information against the other two tables. If there isn't a match, i need to be able to track that row.
anyway here is the query
SELECT COUNT(*) FROM
((ETL_STAGE2 T1 RIGHT OUTER JOIN INTERFACES T2
RTRIM (UPPER (T2.NAME )) = RTRIM (T1.TXT_COMPONENT ) AND
RTRIM (T1.TXT_HOSTNAME ) = UPPER (RTRIM (T2.DEVICE_NAME_____ )))
RIGHT OUTER JOIN SITES T3
UPPER (T2.DEVICE) = UPPER (T3.DEVICE ))
T3.CUSTACCT = 'abc123' AND
T3.ORDER_STATUS = 1
When executed from sqlplus , I get the following error message: