Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    Maryland
    Posts
    152

    Unanswered: Increament in Join

    HI,

    how can we increament in join condition in SQL Server. I have oracle code which is like this...can you please translate it in slq server

    AND B2.RANK_NUMB (+) = B1.RANK_NUMB + 1

    any help will be apprecaited
    mr_roomi

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    I think this might work: LEFT JOIN [tablename here] B2 ON (B1.RANK_NUMB + 1 = B2.RANK_NUMB)

  3. #3
    Join Date
    Mar 2004
    Location
    Maryland
    Posts
    152

    Cool hi

    thank you very much . It worked excellent.
    mr_roomi

Posting Permissions

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