Posted Sun, 05 Aug 2012 15:15:00 GMT by Portal Admin

I am getting the following error when attempting to import a QRY view that has join files in it:
Additional Message Information

Message ID . . . . . . : QRY2303 Severity . . . . . . . : 00
Message type . . . . . : Diagnostic
Date sent . . . . . . : 08/05/12 Time sent . . . . . . : 09:48:45

Message . . . . : Identifier LEFT preceeding ' OUTER JOI' follows proper SQL
statement.
A valid SQL statement could be interpreted from the string you provided if
Identifier LEFT and all subsequent characters (' OUTER JOI'...) were to be
ignored. Change the statement and try again. If you are using *SEQUEL
object authority checking, the problem may be caused by unsupported usage of
runtime variables.

Has anyone else encountered this?

Posted Thu, 16 Jun 2016 05:00:00 GMT by Portal Admin

Try 'Partial Outer Join' instead of 'Left Outer Join' unless you are using remote connection to SQL Server and using SQL Server Syntax as opposed to Sequel ViewPoint auto conversion.

Originally Posted By [email protected]

You must be signed in to post in this forum.