Converting Sybase ASE-specific = and = into LEFT/RIGHT OUTER JOIN

Question

I have some PHP applications running on Sybase ASE 15.0.2, and I need to port them to MicroSoft SQL Server 2008 R2. Many of the queries use the Sybase-only syntax with *= and =* Is there an automatic way to convert a query from the Sybase syntax to the standard syntax using LEFT/RIGHT OUTER JOIN ?

I really mean automatic. I know how to do it manually, but the queries are many and complex. — carlo.borreo

Diego Diego · Accepted Answer · 2012-10-18T09:07:44

*= indicates a left outer join

=* indicates a right outer join

so

select * 
from tableA, titleauthor
where tableA.ID *= titleauthor.ID

means

select * 
from tableA left join titleauthor
on tableA.ID = titleauthor.ID

I dont think you will find a tool to do it automatically for you. Even though is simple, it can get tricky and an automated process wouldnt be 100% reliable (I think)

Converting Sybase ASE-specific *= and =* into LEFT/RIGHT OUTER JOIN

2 Answers

Converting Sybase ASE-specific = and = into LEFT/RIGHT OUTER JOIN