>Hi,
>What wrong with this sql? It works in command window, but cause error "SQL column 'iiD' is not found" from view designer and dataenvironment.
>

The problem is the order of your ON clauses. When you use nested joins (as the View Designer in VFP 7 and earlier does), the first ON is matched with the last two tables listed.

For example:

FROM Table1 ;
JOIN Table2 ;
JOIN Table3 ;
ON Table2.Key = Table3.Key ;
ON Table1.OtherKey = Table2.OtherKey

You need to reorganize the ON clauses in your query. If you're using the View Designer in a version earlier than VFP 8, you may find it difficult to get a complex query right and have to define it by hand.

Tamar