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