See attached; I have two tables with all the same columns EXCEPT one.
I'm trying to do this:
SELECT * from task, cl_task c where c.cid = 0 order by tgroup, category, subcategory, subsubcategory
#1052 - Column 'tgroup' in order clause is ambiguous
Of course tgroup is in both tables, as is category, subcategory, etc.
Do I have to use union or join or ??