It appears that the vfp odbc driver does not support outer joins. I am trying to use MS query to return a result set from som vfp free tables. It does an inner join fine but no outer join is possible. Does anyone have some ideas ?