Viewedit for VFP 6.0 seems to have to the same limitation with 'left joins' in remote views.

Bsically it used UI and DBSETPROP command to create the views ending with the same problem. I guess in addition to a workaround in VFP 6.0, Version 8.0 is my best hope.

Could you verify for me whether VFP 8.0 supports 'Left Join' between 2 remote views or more?

That would be great help.