How can we help you today? How can we help you today?

order by?

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?
smilee282000
0

Comments

2 comments

Sort by
  • 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,
    Matthew Flatt
    0
  • smilee282000
    Yes. That works! I knew it would be simple. :lol: Thanks!
    smilee282000
    0

Add comment

Please sign in to leave a comment.