I am new to MySQL and am trying to convert : SELECT SUM(DistKm) AS Distance FROM (SELECT TOP 5 DistKm FROM XCLeague WHERE LoginID='billyreed' AND HGPG='PG' ORDER BY DistKm DESC)
This is a subselect which selects the top 5 cross country flight distances of hang glider pilots (for a specific pilot) and then sums the result for each pilot. Subsequent code writes this to a new table showing who is in the lead !! Can anyone suggest how this is done in MySQL. It doesnt seem to like the TOP 5 syntax. I have been able to convert the rest of my site from MS Access to MySQL but am struggling with this. many thanks in anticipation. Billy Reed --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
