General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only