Need help with sql

Hi folks,

        I have another question for
you. I have written a query using UNION operator. I have tested these two
queries seprately and they work well, but when I use the UNION an error
appears telling me that UNION is an unknown command.. strange!

here is my query :

SELECT input_date, SUM(totbo) as USCO_TOTBO, SUM (xci_count) as XCI_TOTBO
FROM
(SELECT input_date, totbo, 0 as xci_count

	FROM uscobosum 
	WHERE input_date >= ADD_MONTHS(sysdate,-24) and

 UNION  SELECT input_date,0 as totbo, sum(totbo)

  	FROM xci_bo 
 	WHERE input_date >=ADD_MONTHS(sysdate,-24)
  	GROUP BY input_date

think you help me. Received on Thu Dec 06 2001 - 15:36:06 CET