I have an sql statement with a union that works fine until I add some additional criteria to the where clause and I get this error. (this is in VFP5) I have tried to make sure that the where clause is almost identical for obth the 1st and 2nd selects. Is there something I should be watching out for? I thought that the union should work based upon the fields in the select part and be independant of the where clause.