• an identity column against each row would serve the purpose.....

    you can use merge join then