I have a SQL query that joins another select statement. If the main query is null, I still want to pull from the nested query. Is this even possible or would I need to create 2 temp table and do that?
SELECT E.ID, E.NAME, E.DEPT_ID, A.DEPT_DESC, E.PAYRATE FROM EMPLOYEE E
FULL OUTER JOIN
(SELECT D.DEPT_ID, D.DEPT_DESC FROM DEPT D) A ON A.DEPT_ID = E.DEPT_ID
2912 Joe Smuack 122 MIS $22.00
NULL NULL NULL FIN NULL