>Hi all,
>
>i want a single sql command .
>I WANT count a field of 2 tables with union clause
>
>I want 2 for result of ncount() && {^2009/10/01}
>
>

> m.d_debut = {^2009/10/01}
>
>  CREATE CURSOR Temp1 ( Ch1 D(8) )
>
>  INSERT INTO Temp1  VALUE( m.d_debut )
>  INSERT INTO Temp1  VALUE(m.d_debut + 1 )
>  INSERT INTO Temp1  VALUE(m.d_debut + 2 )
>  INSERT INTO Temp1  VALUE(m.d_debut + 3 )
>
>
>  CREATE CURSOR Temp2 ( Ch1 D(8) )
>  INSERT INTO Temp2  VALUE( m.d_debut )
>
>  SET ENGINEBEHAVIOR 90
>  SELECT Temp1.Ch1 ,;
>    COUNT(Temp1.Ch1) AS NCOUNT  GROUP BY 1 FROM Temp1;
>    UNION;
>    SELECT Temp2.Ch1,;
>    COUNT(Temp2.Ch1) AS NCOUNT  FROM Temp2;
>    GROUP BY 1 INTO CURSOR temp
>
>

>
>The result is bad...

	d_debut = {^2009/10/01}

  CREATE CURSOR Temp1 ( Ch1 D(8) )

  INSERT INTO Temp1  VALUE( m.d_debut )
  INSERT INTO Temp1  VALUE(m.d_debut + 1 )
  INSERT INTO Temp1  VALUE(m.d_debut + 2 )
  INSERT INTO Temp1  VALUE(m.d_debut + 3 )


  CREATE CURSOR Temp2 ( Ch1 D(8) )
  INSERT INTO Temp2  VALUE( m.d_debut )

  SET ENGINEBEHAVIOR 90
  select ch1, ;
  	sum(ncount) as nCount ;
  	from ( ;
		  SELECT	Temp1.Ch1 ,;
		    	COUNT(Temp1.Ch1) AS NCOUNT  ;
		    FROM Temp1 ;
		    GROUP BY 1 ;
		    UNION all ;
		  SELECT	Temp2.Ch1,;
	   		COUNT(Temp2.Ch1) AS NCOUNT ;
	   	FROM Temp2;
   		GROUP BY 1 ;
   	) X ;
   	group by 1 ;
   	INTO CURSOR temp