>SELECT Office.ofc_cde, Office.ofc_name, Office.ofc_seq_num,;
> Ofc_fnctn_link.fnctn_cde, Function.fnctn_desc,;
> Ofc_fnctn_link.ofl_expir_dte, Ofc_fnctn_link.ofl_addr,;
> Ofc_fnctn_link.ofl_city, Ofc_fnctn_link.state_abbr, State.state_name,;
> Ofc_fnctn_link.ctry_abbr;
> FROM ofc_fnctn_link Ofc_fnctn_link, office Office, function Function,;
> {oj state State LEFT OUTER JOIN country Country ;
> ON State.ctry_abbr = Country.ctry_abbr };
> WHERE Office.ofc_seq_num = Ofc_fnctn_link.ofc_seq_num;
> AND Ofc_fnctn_link.fnctn_cde = Function.fnctn_cde;
> AND Ofc_fnctn_link.state_abbr = State.state_abbr;
> AND State.ctry_abbr = Country.ctry_abbr;
> ORDER BY Office.ofc_cde, Office.ofc_name, Ofc_fnctn_link.fnctn_cde,;
> Function.fnctn_desc, Ofc_fnctn_link.ofl_city, Ofc_fnctn_link.ctry_abbr
>
>
>In regards to the SQL statement that VFP produces in the Remote View Wizard using the LEFT OUTER JOIN, the above SQL is produced. VFP will not let you save this view because of this error.
>
>Connectivity error: [Microsoft][ODBC Visual FoxPro Driver] Comannd contrains unrecongnized phrase/keyword.
>
>I think VFP does not recognize the '{' symbol in the SQL.
>
>{oj state State LEFT OUTER JOIN country Country ;
> ON State.ctry_abbr = Country.ctry_abbr };
>
>I know there is a program to let you change an SQL then upload it to a remote view, but this backend will later change to Oracle and it would probably work fine.
>
>Thanks for responding.

The problem may actually be with the VFP reserved word *function*. You should avoid having a table name, field name, any arbitrary name, the same as a reserved word. The use of this name may also give you problems when you upsize to Oracle.

I saw you had another thread on this, so I don't remember if you said you tried creating this programmatically (in a .PRG or .QPR) after changing the braces to parentheses.