>Hello all
>
>say a have view which joins 3 or 4 tables together
>when I issue an

Does your view correctly have all fields?

Try
>

>Select field1, field2, field3 from dbf('theView') WHERE field2 = "somecondition"
>

>

Or do
select view
copy to temptable
and use temptable...
>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