[groupby] Forum Topics

I am using MySQL 5.0 on WinXP pro. Below is the script for creating the table CREATE TABLE `tbl_test` ( `gameID` VARCHAR(45) NOT NULL, `gameName` VARCHAR(100) NOT NULL, `gameStartDateTime` DATETIME NOT NULL ); INSERT INTO `tbl_test`(`gameID`,`gameName`,`gameStartDateTime`) values('gameID1','gameName1','2008-01-01 1:00:00'); INSERT INTO `tbl_test`(`gameID`,`gameName`,`gameStartDateTime`) values('gameID1','gameName1','2008-01-01 8:00:00'); INSERT INTO `tbl_test`(`gameID`,`gameName`,`gameStartDateTime`) values('gameID1','gameName1','2008-01-01 12:00:00'); I would …

I have two tables representing two forms that are connected each other but a form number. The second form records a number and a timestamp. This form can record multiple entries with a timestamp for each entry. I need a SQL statement that will return the first entry on Form2 …