>Hi,
> I am developing multiuser application. I have a query which need to join 3 tables through network. Could I know, which way of SQL coding is faster?
>
>1. Join 3 tables in ONE SQL Statement
>
>2. Firstly, join 1st and 2nd table and then join the 2nd with the 3rd table.
>
>
>Thank you
It is difficult to answer. It depends on the amount of data in the tables, which ones you join first in #2, the indeces, etc. FYI, Fox always joins two tables at a time, so even if you use #1, internally VFP will do #2. There is a more complete description about joins in the Rushmore KB article on my web site. (Click the company name above).
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer