Foxpro cannot disregard table3 and table4 because the join on table3 and table4 could affect the number of records returned.
>Hello all
>
>say a have view which joins 3 or 4 tables together
>when I issue an
>
>Select field1, field2, field3 from theView WHERE field2 = "somecondition"
>
>
>saying that the fields in the select statement are only from table1 and table2
>
>would the join on table3 and table4 interally in the view be executed or is
>FoxPro clever enough to omit them?
>
>Christian
--sb--