Information générale
Catégorie:
Codage, syntaxe et commandes
>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement