title: How multi select in a Select?
body: <p>i'm a lost in this case.</p>
  
  <p>I want to do a SELECT  with two select in. Is that possible? 
  I've already try UNION. Do you have any idea ? :(</p>
  
  <p>Here is my quest : (SQL - ORACLE)</p>
  
  <pre><code>SELECT 
      PCTX_LA0,
      PCTX_LA1,
      PCTX_LA3,
      PCTX_LA2_LA4,
      PCTX_LA5,
      CTX_ACTION1,
      CTX_ACTION2,
      CTX_DATE
  FROM (
      --Précontentieux
      SELECT     
          CASE KLIGCONT.COENTAC WHEN 'LA0' THEN KLIGCONT.CODSIT ELSE NULL END AS PCTX_LA0,
          CASE KLIGCONT.COENTAC WHEN 'LA1' THEN KLIGCONT.CODSIT ELSE NULL END AS PCTX_LA1,
          CASE KLIGCONT.COENTAC WHEN 'LA3' THEN KLIGCONT.CODSIT ELSE NULL END AS PCTX_LA3,
          CASE KLIGCONT.COENTAC WHEN 'LA2' THEN KLIGCONT.CODSIT WHEN 'LA4' THEN KLIGCONT.CODSIT ELSE NULL END AS PCTX_LA2_LA4,
          CASE KLIGCONT.COENTAC WHEN 'LA5' THEN KLIGCONT.CODSIT ELSE NULL END AS PCTX_LA5
      FROM LOGI.KLIGCONT KLIGCONT
      WHERE KLIGCONT.COPROC='BOBS'
      AND KLIGCONT.COVALID='O'   
  
  
      --Contentieux
      SELECT    
          KLIGCONT.COENTAC AS CTX_ACTION1,
          KCOENTAC.COLIBEVE AS CTX_ACTION2,
          KLIGCONT.CODSIT AS CTX_DATE
      FROM 
          LOGI.KLIGCONT KLIGCONT,
          LOGI.KCOENTAC KCOENTAC 
      WHERE KLIGCONT.SCSO = KCOENTAC.SCSO 
      AND KLIGCONT.COENTAC = KCOENTAC.COENTAC
      AND KLIGCONT.COPROC='COMM'
      AND KLIGCONT.COVALID='O'
     )
  </code></pre>
  
  <p>Thx in advice..</p>