>I have a serious problem.
>it's impossible to create a view with
>more of one left outer join condition from
>view designer.
>I think that it's a bug of VFP 5.0
>because i can see from code sql generated that view designer use a syntax that Microsoft too , say that is wrong, in FAQ of VFP CD.
>I really need of help.
>Hello.

There is one way to bypass the view designer. Just use the sql code and put it like this :

CREATE SQL VIEW "NAME" AS
SELECT...

With that method, if you want to use the UPDATE CRITERIA. It is more "painful" to do. For each updatable field, you must use CURSORSETPROP().

But, Put all tthe code in a script program. You can modify the view whenever you want.