General information
Category:
Coding, syntax & commands
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only