>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

The answer depends on how big the tables are and the types of joins involved. Gnerally, three table joins will not cause problems. I think VFP supports up to seven table joins. In my experience, however, I have found that eanything over three tables tends to impact performance. The best thing to do is test each scenario and decide for yourself.