Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't find column error on outer join
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00515388
Message ID:
00515567
Views:
17
>>SELECT * ;
>>   FROM nonConf nc ;
>>      LEFT JOIN car_misc cm ON nc.car_id = cm.car_id ;
>>      LEFT JOIN car_extension ce ON nc.car_id = ce.car_id
>>   INTO CURSOR car_temp
>
>Worked as advertised. Thanks for the explanantion. I was just cutting and
>pasting the code from the query designer without really examining it too
>closely.

My pleasure. :-) You could probably get the nested form to work by switching it around, but this is easier, IMHO.
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Previous
Reply
Map
View

Click here to load this message in the networking platform