Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select sql join question ???
Message
 
À
11/06/1997 18:00:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00035992
Message ID:
00036017
Vues:
61
>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 ...
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform