We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
WITH FIRST_QUERY AS (SELECT M.ID FROM TABLE1 M INNER JOIN TABLE2 PER ON (PER.ID = M.ID) WHERE M.COMP IN ('ACCOMP1' ,'ORG2')) WITH SECOND_QUERY AS (SELECT N.ID FROM TABLE3 N WHERE TYPE IN ('102' ,'103') AND SEQ = '1' --current row of data, if desired AND STATUS = 'A' --active ('I' = inactive), if desired ) SELECT * FROM FIRST_QUERY FULL OUTER JOIN SECOND_QUERY ON (N.ID = M.ID)
Join the community of 500,000 technology professionals and ask your questions.