Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is there a way to speed this SELECT up?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00446204
Message ID:
00446213
Views:
8
>Here is the correct SELECT code. I mistakenly put the wrong code in the first message. Oooooops!
>
>
>SELECT master.incident, master.patnum, master.patqty, master.name_last, master.name_first, ;
>	master.sitename, master.addr1a, master.citya, ;
>	master.mcoid, arrest.sca_ctr, master.date, arrest.closed ;
>	FROM master, arrest ORDER BY master.date INTO ARRAY slister
>
>
>Sorry about that.

Probably because you got a nice little Cartesian product going on there ;)
Insanity: Doing the same thing over and over and expecting different results.
Previous
Reply
Map
View

Click here to load this message in the networking platform