Microsoft KB Archive/148249

= DOC: Help File Example for SELECT SQL UNION Does Not Work =

Article ID: 148249

Article Last Modified on 9/30/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 3.0b Standard Edition

-



This article was previously published under Q148249



SUMMARY
Visual FoxPro's Help information for SELECT - SQL gives an incorrect example of how to use the UNION clause. It will return the following error if you try to run it:

SELECTs are not UNION compatible

This documentation error has been fixed in Visual FoxPro 5.0 for Windows.



MORE INFORMATION
The placeholders for orders.order_id and orders.emp_id in the second SELECT are for the wrong data type. The placeholders are for numeric fields and they should be for character fields. The example should read as follows: SELECT customer.company, orders.order_id, orders.emp_id ; FROM customer, orders ; WHERE customer.cust_id = orders.cust_id ; UNION ; SELECT customer.company, ,  ; FROM customer ; WHERE customer.cust_id NOT IN ; (SELECT orders.cust_id FROM orders)

Additional query words: docerr VFoxWin 5.00

Keywords: kbdocfix KB148249

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.