Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Change numeric width
Message
From
08/04/2004 05:05:33
 
 
To
08/04/2004 02:18:22
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00893180
Message ID:
00893209
Views:
17

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 ...
Previous
Reply
Map
View

Click here to load this message in the networking platform