Hi,
> I have two separate queries that work individually, returning a count from each column.
> I would appreciate any pointers.
> new_sup, COUNT(new_sup) AS new_sup_count
> old_sup, COUNT(old_sup) AS old_sup_count
At least some of your problem is here - in your UNION-ed table, this is one and the same field and therefore cannot
havetwo different names.
HTH,
SQL Padawan