I know that my ODBC is configured correctly because the Crystal report runs ...

How can I get VFP to SELECT like data.
Crystal =

 SELECT "pat_cur_demo"."pat_cur_demo", "pat_cur_demo"."FACI", "pat_cur_demo"."PATID", "pat_cur_demo"."d_o_b", "tab_fac_def"."fac_num", "tab_fac_def"."FACI", "tab_fac_def"."dss_facid"
 FROM   "AV"."APMDSS"."tab_fac_def" "tab_fac_def" INNER JOIN "AV"."APMDSS"."pat_cur_demo" "pat_cur_demo" ON ("tab_fac_def"."FACI"="pat_cur_demo"."FACI") AND ("tab_fac_def"."dss_facid"="pat_cur_demo"."dss_facid")

TIA