Re: SELECT TOP 3 scores in each class with JOIN
There is is no edit post!
messed up the insert...
INSERT INTO `HWData` (`entrynum`, `fname`, `lname`, `club`, `make`, `model`, `year`, `class`, `score`, `dsqreason`, `award`) VALUES
(1, 'Samuel', 'Nevarez', 'Texas Money Making Cartel', 'Chevrolet', 'Silverado', 2003, 'FULL SIZE GM 07 - UP', '84.0', '', 'Best Truck'),
(2, 'Alex', 'Navarro', 'BMF', 'Ford', 'JVT', 2003, 'FULL SIZE GM 88 to 06', '17.5', 'DQB - Disqualified Burnout', ''),
(3, 'Enrique', 'Cruz', 'Draztik', 'Chevrolet', 'Silverado', 2008, 'FULL SIZE GM 07 - UP', '59.5', '', ''),
(4, 'Francisco', 'Gonzalez', 'Los Ansiosos', 'Chevrolet', 'Silverado', 1992, 'FULL SIZE GM 07 - UP', '62.0', '', ''),
(5, 'Jose', 'Flores', 'Los Ansiosos', 'Chevrolet', 'Silverado', 2003, 'FULL SIZE GM 88 to 06', '88.5', '', 'Best of Show'),
(6, 'David', 'Villanueva', 'Most Wanted', 'Chevrolet', 'Silverado', 2008, 'FULL SIZE GM 07 - UP', '61.0', '', 'Best Engine'),
(7, 'Luis', 'Rodriguez', 'Most Wanted', 'Chevrolet', 'Silverado', 2003, 'FULL SIZE GM 88 to 06', '59.5', '', ''),
(8, 'Jerry', 'Rodriguez', 'Most Wanted', 'Chevrolet', 'Silverado', 2001, 'FULL SIZE GM 88 to 06', '65.0', '', 'Best Interior');