chris_jolly
Registered User.
- Local time
- Today, 13:18
- Joined
- Jul 27, 2007
- Messages
- 24
Hello,
I have a link table where I am forming a union query from and would like to take a specific set of data. The table is a timestamp table and I would like to grab the most recent entry. So in theory, I want the max value for the timestamp. I writing this in sql to facilitate the union query.
Table: Time Submitted - ####(corresponding plant)
Fields: Plant, Version, Timestamp
So I want to take the plant, version, and timestamp that corresponds to the most recent Timestamp
This is my current SQL, i dont know if the where statement is correct
Select *
From [Time Submitted - ###]
Where ????
I have a link table where I am forming a union query from and would like to take a specific set of data. The table is a timestamp table and I would like to grab the most recent entry. So in theory, I want the max value for the timestamp. I writing this in sql to facilitate the union query.
Table: Time Submitted - ####(corresponding plant)
Fields: Plant, Version, Timestamp
So I want to take the plant, version, and timestamp that corresponds to the most recent Timestamp
This is my current SQL, i dont know if the where statement is correct
Select *
From [Time Submitted - ###]
Where ????