Omabala

Could someone please tell me how to retrieve a table so that one column simply displays something and another column counts something for example: SELECT COUNT(u_id), SELECT countryName FROM _AEsurvey_rego WHERE countryName LIKE ('China') GROUP BY countryName; but I get this error message: #1064 - 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 countryName  FROM _AEsurvey_rego  WHERE countryName LIKE ( 'China' )  GRO' at line 1 Cheers.

Im trying to retrieve information from 3 different tables and end up with a table with 5 columns: 1st column displays vis_type 2nd column displays countryName 3rd column displays the total number of u_id 4th column displays average score of aesth_rank and 5th column displays average score of x_pos MySQL keeps telling me something is wrong with my 2nd line...it seems to not like how i type SELECT COUNT (...) Can any1 tell me all the errors in my query...I'm just a beginner SELECT a.vis_type, c.countryName AND SELECT COUNT (‘a.u_id’) AND SELECT AVG(‘a.aesth_rank’) AND SELECT AVG(‘b.x_pos’) FROM _AEsurvey_meta_info a, _AEsurvey_aesth_rank b, _AEsurvey_rego c WHERE (a.vis_type = '1' AND c.countryName LIKE ('China')) OR (a.vis_type=’2’ AND c.countryName LIKE (‘China’)) AND a.u_id = b.u_id AND b.u_id = c.u_id GROUP BY a.vis_type; Thanks.