order by?
smilee282000
Posts: 3
This may be a stupid question but how do I specify the order the data should be compared in. For example, I am comparing tables where the data may be identical but they are in the database in different orders. I would like to say: order by column 1 on both & then have it compared. Is that something I can check off somewhere?
Comments
If I have grasped this right, you should be able to set Column 1 as your comparison key. Rows of data with the same value in this column will then be compared. You can select your comparison column in the Tables & Views tab when setting up your project.
I hope this helps,
Redgate Foundry