Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Select w/ Union
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00215861
Message ID:
00215867
Views:
27
left out the semi-colon after the union:
>>

>>SELECT ;
>> FField1 AS Field1, ;
>> FField2 AS Field2 ;
>> FROM myTable1 ;
> union ;
>>SELECT ;
>> BField1 AS Field1, ;
>> BField2 AS Field2 ;
>> FROM myTable2 ;
>>INTO CURSOR myCursor2 NOFILTER
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform