Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select sql join question ???
Message
 
To
11/06/1997 18:00:03
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00035992
Message ID:
00036017
Views:
64
>Here's my guess:
>
>SELECT * FROM Table1;
> INNER JOIN Table2 ON Table1.Vend_id=Table2.Vend_id;
> INNER JOIN Table3 ON Table1.Cust_id=Table3.Cust_id;
> WHERE Table1.Cust_id>1000;
> ORDER BY Table1.Cust_id;
> INTO CURSOR JUNK
>
>I wrote this SQL without having taken a look at yours, and it happened to be about the same. :) However, I didn't test it.
>
>I guess you have tags on Table1.Cust_id, Table2.Vend_id, Table3.Cust_id. Are you running with SET DELETE ON? If yes, you may want to add a tag on DELETED() as well for those tables.
>
>Might it also be possible that the result is pretty big?

Hi Mike Your Guess is Good
I test it and it work's fine

Mike i did a VCX editor. It's not all finish but i think that is not to bad.
Do you want take a look on it and give me your opignion ?

Rocky Boy ...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform