>The ON.. clause is for relating the two tables so I would think that this would be the proper behaviour. VFP cannot finish the relationship without it. You might try...
>CREATE SQL VIEW "LV_OBJECTDECORATORLIST" ;
>AS SELECT Decorator.winobjkey, Decorator.decobjkey,;
>Decorator.decoratorname, Decorator.price, Objdeco.objdecokey,; objdeco.objcompkey, NVL(Objdeco.default, .F.) AS ldefault,;
>Objdeco.default, IIF(ISNULL(Objdeco.objdecokey),.F.,.T.) AS checked FROM ;
>vwin!decorator LEFT OUTER JOIN vwin!objectdecorator Objdeco ;
>ON Decorator.decobjkey = Objdeco.decobjkey ;
>WHERE Decorator.winobjkey = ?v_winobjkey and objdeco.objcompkey = ?v_objcompkey

I need this view to select all decorators, whether or not there is a related record in objdeco. If I put the parameter in the where clause, it filters out the outer join records I want so that won't work. The view does work, and I solved my problem (I use codebook so all my view are subclassed cursors so I added the parameter to opentables with a value of 0 which isn't quite the same as nodata but does provide the same result. It is just interesting that with this type of query, nodata does not work!