Showing posts with label slq. Show all posts
Showing posts with label slq. Show all posts

Wednesday, March 28, 2012

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 apprecaitedI think this might work: LEFT JOIN [tablename here] B2 ON (B1.RANK_NUMB + 1 = B2.RANK_NUMB)|||thank you very much . It worked excellent.