>In your Suggested SQL also the First Two records are Same. Why ? How to Overcome That ?
>
>
I don't have your data, but did you examine every column (from each of the tables) to verify that data are indeed exactly the same? Most likely they are not the same for the columns you may not be interested in.
If it's not broken, fix it until it is.
My Blog