title: UNION / ORA-00933: SQL command not properly ended
body: <p>I'm getting a "<code>ORA-00933: SQL command not properly ended</code>" error message when I run this code.  I've checked commas, parenthesis, etc. and cannot find what is wrong with this.  Any suggestions?  This is the first time that I have used UNION ALL in my code.  The first part of the union does exactly what I looking for.  I've added the second part of the union because I only want those couple of fields for fiscal year 2014 and accounting period 11 only.  I dont want that information for accounting period 10 in this part even though I do want it in the first part. Thanks for the help</p>
  
  <pre><code>Select
      Bus_UNIT, 
      DESCRIPT,
      DEPTID,
      ASSET_NO,
      ACCT_AD,
      BOOK,
      CURRENT_AMT,
      PRIOR_AMT,
      ACCT_DE,
      JRNL_ID,
      JRNL_DT    
  From ( SELECT 
      pa.BUSINESS_UNIT as BUS_UNIT, 
      pa.DESCR AS DESCRIPT,
      pdr.DEPTID AS DEPTID, 
      pdr.ASSET_ID AS ASSET_NO, 
      pdr.ACCOUNT_AD AS ACCT_AD, 
      pdr.BOOK AS BOOK,
  
      MAX(CASE WHEN (pdr.FISCAL_YEAR =2014 AND pdr.ACCOUNTING_PERIOD =11) THEN  pdr.DEPR END) as CURRENT_AMT,
      MAX(CASE WHEN (pdr.FISCAL_YEAR =2104 AND pdr.ACCOUNTING_PERIOD =10) THEN pdr.DEPR  END) as PRIOR_AMT,
  
      '' AS ACCT_DE,
      '' AS JRNL_ID,
      '' AS JRNL_DT
  
      FROM PS_ASSET pa
  
      INNER JOIN PS_DEPR_RPT pdr 
      ON pa.ASSET_ID = pdr.ASSET_ID
      AND pa.BUSINESS_UNIT = pdr.BUSINESS_UNIT
  
      WHERE 
      pa.BUSINESS_UNIT='A0465'
      AND pdr.BOOK='PERFORM'
      AND ((pdr.FISCAL_YEAR=2014 AND pdr.ACCOUNTING_PERIOD=11) 
      OR (pdr.FISCAL_YEAR=2014 AND pdr.ACCOUNTING_PERIOD=10))
  
      group by
      pa.business_unit,
      pa.descr,
      pdr.deptid,
      pdr.asset_id,
      pdr.account_ad,
      pdr.book
  
  UNION ALL
  
      select
      '' as BUS_UNT,
      '' AS DESCRIPT,
      '' AS DEPTID, 
      '' AS ACCT_AD, 
      '' AS BOOK,
      '' AS CURRENT_AMT,
      '' AS PRIOR_AMT,
      pdl.asset_id AS ASSET_NO,
      pdl.account AS ACCT_DE,
      pdl.journal_id AS JRNL_ID,
      pdl.journal_date AS JRNL_DT
  
      from ps_dist_ln pdl
  
      where
      book = 'PERFORM'
      and business_unit = 'A0465'
      and fiscal_year = 2014
      and accounting_period = 11
      and distribution_type = 'DE'
  ) as TEST    
  group BY ASSET_NO;
  </code></pre>