Unanswered: Converting outer join from Transact-SQL syntax into ANSI syntas
I'm trying to convert a clause into ANSI syntax because I have trouble ruuning the query in a 12.5 ASE. The thing is I can´t get around converting this clause (it's one of the WHERE clauses of a larger query, but its the only one im missing)
AND INT_RenovRechazos.FechaRechazo=*(select Max(FechaRechazo) from INT_RenovRechazos where Operacion=*Operacion.Operacion and IdAseguradora=*PolizaSeg.IdAseguradora)
Can someone throw me any clues? I'm quite new with Sybase, any hints very much appreciated.
Thanks a lot