## Combining "unrelated" SQL select statements


   SELECT NAME    
   FROM   EMP
   WHERE  EMP_NO = 1234;

   SELECT NAME 
   FROM   DPT
   WHERE  DPT_NO = 10;

   SELECT  NAME
   FROM   CAT
   WHERE  CAT_TYPE = 'RD'  ;



   SELECT E.NAME, D.NAME, C.NAME
   FROM   CAT  C,
          DPT  D,
          EMP  E,
          DUAL X
   WHERE  NVL('X', X.DUMMY) = NVL('X', E.ROWID (+))
   AND    NVL('X', X.DUMMY) = NVL('X', D.ROWID (+))
   AND    NVL('X', X.DUMMY) = NVL('X', C.ROWID (+))
   AND    E.EMP_NO   (+)    = 1234
   AND    D.DEPT_NO  (+)    = 10
   AND    C.CAT_TYPE (+)    = 'RD'