I have a remote view that consists of two tables joined with an outer view. I want to add a third table. When I try to save this, VFP5 gives me an error message that I don't understand. When I try to duplicate this using Microsoft Query, MS Query reports that only two tables can be used when using an outer join.

Is this a microsoft limitation? Or an SQL limit?

I'm trying to create a view that contains all records in Table A, all records in Table B that have a match in Table A, and all records in Table C that have a match in Table A. And when I change the record pointer in Table A, I want the corresponding records in Tables B & C to display.

Is this possible?

Jeff