> >
> > you can't union 2 select statements where each statement has a different
> > number of fields or have different data types.
> > Alan
>
>
> That I knew - I wasn't not comlaining about that.
> More the errormessage ... ;-)
>
> Miv

Invalid command count of
column list and variable list do not match

that's exactly what it means to me.
invalid command....
count of column list and variable list do not natch
you are declaring a count of columns in the first select. You are not
matching this count in the second select.
Alan