Unanswered: Syntax Error in SQL query can figure out what it is. please help
i have a query when i run it it sys "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT customerID, count(adID) AS noOfAds FROM a"
my query is
SELECT c.customerID, c.firstName, c.Email, c.membershipType, a.noOfAds FROM customerInfo c, (SELECT customerID, count(adID) AS noOfAds FROM adInfo Group BY customerID) a WHERE c.customerID = a.customerID ORDER BY firstName ASC