Using latest versions of both ASP.NET and MySQL. I want to create a query returning only the TOP 10 rows of data, but using LIMIT does not seem to work. (This is a query within an XSD dataset.)
Putting the LIMIT after the WHERE and after the ORDER BY
The TableAdapter Query Configuration Wizard tells me: Error in SELECT clause: expression near '10'. Unable to parse query text.
What am I missing?
SELECT counties.County, states.UsStateAbbreviation, projects.ProjectId, projects.ProjectTitle
FROM states INNER JOIN
counties ON states.StateId = counties.StateId INNER JOIN
projects ON counties.CountyId = projects.LocationCountyId
WHERE (projects.IsVisible = 1) AND (projects.ReleaseDate <= CURDATE()) AND (projects.IsPrivate = 0)
ORDER BY projects.BidDateTime DESC