General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Remote view and outer join
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only