>I have a two select statements that have the same number of columns and the columns are the same data type and length. In the first select I group by one column and use the sum function on a couple of fields. I then use a union select ie select * from first cursor union select * from second cursor. I get the error - selects are not union compatible. I don't understand why they arn't compatible. I don't use group by in the union select statement so the number of columns and their data types and lengths match so what is wrong? Any ideas would be much appreciated. Thanks.
>
>Rhea Urusky
>rheau@beaverplastics.com

You can only have 1 group by and 1 order by clause, and these have to be at the end of the SQL statement.