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...