I have a 1-to-many relationship between my "Game" and "GameInfo" tables.
TABLE: Game
GameID, GameName
TABLE: GameInfo
GameInfoID, GameID, DateTimeOfThisPieceOfInfo, GameInfo
Let's assume that there are multiple records in GameInfo for GameID 1. I want to write a query that only returns the row of GameInfo where the "DateTimeOfThisPieceOfInfo" is the latest date. For clarity, here's how I would write the query to return multiple rows. Can someone help me write the query so it only returns the 1 row of GameInfo that has the latest date...
SELECT g.GameName, gi.GameInfo
FROM Game g
JOIN GameInfo gi
ON g.GameID = gi.GameID
WHERE g.GameID = 1