Outer joins are currently disabled

[Former Member]

I have similar code as below, in a procedure. The code works fine in the older versions of Sybase, but in the newer versions, I get the error message 'Transact-SQL outer joins are currently disabled.'

SELECT  table1.a,
        table1.b,

        table2.x,
        table2.y,

FROM    table1,
        table2

WHERE ( table1.a *= table2.a )

[VolkerBarth]

In case you have to time to alter those procedures, I would strongly recommend to get rid of those T-SQL outer joins and use standard OUTER JOINs instead.

[Former Member · Accepted solution]

You can re-enable T-SQL outer join support by changing the TSQL_OUTER_JOINS option to ON. See the help. You may also want to read this white paper on the Semantics and Compatibility of TSQL Outer Joins.