order by?

smilee282000

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?

Matthew Flatt

Hi smilee282000,

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,

smilee282000

Yes. That works! I knew it would be simple. :lol: Thanks!