I understand the left outer join vs inner join. In my query the result set using left outer join or inner join is exactly the same due to the where clause. That's the question. Why is VFP not optimizing the left outer join properly even though the first clause in my where statement is on the FROM table where there is an optimizable index tag.