Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Equivalent selects
Message
From
17/09/2008 16:15:09
 
 
To
17/09/2008 16:11:44
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01348392
Message ID:
01348393
Views:
18
This message has been marked as the solution to the initial question of the thread.
>I am assuming these 2 statements are functionally equivalent. Am I correct?
>Thanks
>
>select * ;
>from test_financing ;
>inner join tip on test_financing.tip_id = tip.tip_id ;
>where between(_year,tipyear,tipyear+4) ;
>order by lead, st_name, _year 
>
>select * ;
>from tip ;
>inner join test_financing on test_financing.tip_id = tip.tip_id ;
>where between(_year,tipyear,tipyear+4) ;
>order by lead, st_name, _year 
>
Yes. You will get the same result from both.
But abouth to speed you should check Actual Execution Plan.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform