hi there,
I need to use the union all sql statement, but I have 2 different numeric fields which are (19,2) and (20,2).
How to query if I need to union these two fields?
Thanks
Put in the header select of the union the most wide field:
SELECT .... FIELD202 FROM ...
UNION ALL
SELECT .... FIELD192 FROM ...