Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    4

    Question 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)
    AND.....

    Can someone throw me any clues? I'm quite new with Sybase, any hints very much appreciated.
    Thanks a lot

  2. #2
    Join Date
    Sep 2004
    Posts
    4
    Never mind, I found a workaround to this problem. Thanks for reading

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •