> You are right, I tried it the first way and ran into that problem. Because > I don't have the same columns (number) can I still use a Union? yes you can but you have to put place holders for the other columns (that don't exist in the second SELECT things like SELECT 0000.00 as price,code,otherfield from... unioun; SELECT price, code ,space(10) as otherfield.. Arnon