Hi,

You must have missed 1 or more columns in any one of the query which u are using in UNION.

For example

select x,y from abc
union
select a from xyz will lead to this error.i.e. first query u are using 2 columns and in second 1 column and using union u are trying to join it...

I think this would help u..

Manoj