>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
Can you post some code? The restriction is that the result sets, not the source tables should have the same number of columns and data types.