Hi,

I try to make an Outer Join view on remote data and after the view is made in designer, tested, and saved can't be opened again in designer. The error is 'Command contains unrecognized phrase/keyword '.

The select statement as is generated by designer is :

SELECT Targetp.codtarget, Targetp.opca, Targetp.idpc;
FROM ;
{oj dbo.targetp Targetp ;
LEFT OUTER JOIN dbo.clase Clase ;
ON Targetp.idpc = Clase.idclasa};
WHERE Targetp.codtarget = ( ?fcodtarget )

The error is generated by the "{oj" and "}" after join expression that appear on generated code. Is this a bug? On inner joins this does not appear.

Thanks in advance.