>>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
>>
>>
..snip..
>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.

Also you may want to be sure there's a space before each semi-colon. If not it can cause problems when the statement is parsed.