HELP "SELECT - SQL Command - WITH Clause"do you mean :
SELECT Select_List FROM Table_List ...[WITH (BUFFERING = lExpr)] [WHERE Conditions] [GROUP BY Column_List] [UNION Clause] [HAVING Conditions] [ORDER BY Column_List] [INTO Clause | TO Clause ] [Additional_Display_Options]by
SELECT Select_List FROM Table_List [WITH (BUFFERING = lExpr)] [WHERE Conditions] [GROUP BY Column_List] [UNION Clause] [HAVING Conditions] [ORDER BY Column_List] [INTO Clause | TO Clause ] [Additional_Display_Options]Like print screen updated in attachment ?
FROM [FORCE] Table_List_Item [, ...] [[JoinType] JOIN DatabaseName!]Table [[AS] Local_Alias] [ON JoinCondition [AND | OR [JoinCondition | FilterCondition] ...]can be corrected :
FROM [FORCE] Table_List_Item [, ...] [WITH (BUFFERING = lExpr)] [[JoinType] JOIN DatabaseName!]Table [[AS] Local_Alias] [WITH (BUFFERING = lExpr)] [ON JoinCondition [AND | OR [JoinCondition | FilterCondition] ...]and others pages :
HELP "SELECT - SQL Command"in part "Remarks"
HELP "SELECT - SQL Command - UNION Clause"in part "Remarks"
HELP "SELECT - SQL Command - WHERE Clause"in part "Remarks"
HELP "SELECT - SQL Command - WITH Clause"in part "Remarks"
>SELECT Select_List > FROM Table_List >...[WITH (BUFFERING = lExpr)] > [WHERE Conditions] > [GROUP BY Column_List] > [UNION Clause] > [HAVING Conditions] > [ORDER BY Column_List] > [INTO Clause | TO Clause ] > [Additional_Display_Options]>as "..." (if seen at all) would have not registered on first readings, esp, as not mentioned / linked to from "From" Clause. Might be an idea to forward "With is a clause to from/join, not select" to the person(s) having made the effort to fix vfp help on vfpX.