JohnD

Thank you so much for the answer, I will try this out when I get a little more time. The DateTime values should be the same, I have a program that stores values exactly every hour and hopefully it should be the same all over the tables. About rows, here will be a little problem. As I am adding objects to log and store to database, they will be installed on diffrent times. I have a few object up and running as we speak but more will be added in the future so the row count will not be the same for each table. That is why I want it to check the DateTime instead of a id number that will be diffrent for all tables, will this be a problem in the future you think? I noticed that in my example picture I draw it looks for the ascending order, but I will be looking at the tables descending. Always want to see the latest values. There will be many rows at the end so this might end up slow yes. (Is there anyway to change the title? Little missleading. Somehow I wrote my name instead of an actual explaining title)

Hi! I am a beginner in SQL and trying to understand a few things. We have many values that stores into database, what I am trying to do is what I show in the attached image. Thanks for help