Novice SQL user here. Need help.
I have two tables with the same ID in them that I need to join. The second table has multiple instances of that ID with different timestamps for events. I need to join the two on that ID and return the most recent timestamp. Example:
ID Name EventTime
1 John 2011-02-14
2 Steve 2011-02-14
The timestamps are BIGINT. Not sure if that matters.