Hi Kamil,

Each database engine has it's own query optimizer which desides how to execute particular query by building an execution plan. SQL Server allow you to view the execution plan it produces when you run query in the Query Analizer. After query has been executed, press CTRL+L or corresponded tollbar button/menu item to view it. You can find more about that in BOL.
VFP doesn't provide access to the execution plan. You can only guess and find the best one with trail and error.

>Hi.
>I'd like to know the inner execution sequence when building the result of the following satement.
>

select Pc1.*, Place1.User_Na, Place1.Dep_Pk,
>Dep.Na as Dep_Na from Pc1
>join Place1 on Pc1.Place1_Pk=Place1.pk
>join Dep on Dep.Pk=Place1.Dep_pk
>where Pc1.Place1_PK in
>(Select PK from Place1 where PK in
>(Select Place1_pk from Place1_Po1))
>order by User_na

>Here is how i see it.
>1) WHERE is executed and Pc1 is filtered accordingly.
>2) Place1 is joined to what is left of Pc1.
>3) How Dep is joined to Place1 i don't know. Either Place1 is taken as a seperate table and Dep is joined to it or Dep is joined to what is left of Place1 after it was joined to Pc1 (something i'm aming to achieve).
>4) The result is ordered.
>
>And for that matter, can you direct me to the internet resource which would give a general explenation to the subject (preferably VFP SELECT inner sequence too).
>
>Thank you in advance.
>Kamil.