Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks
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)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.