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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment