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 ) asked 15 Dec '11, 08:08 sam |
You can re-enable T-SQL outer join support by changing the answered 15 Dec '11, 08:23 Glenn Paulley Mark Culp |
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.