Jump to content

Archived

This topic is now archived and is closed to further replies.

Omabala

Problem with query HELP!!!

Recommended Posts

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.

Share this post


Link to post
Share on other sites
There's certainly something odd with the quotes.  In general, you don't need to put any quotes around column names.

[code]SELECT a.vis_type,
          c.countryName,
          count(a.u_id) AS a_u_id_count,
          ...[/code]

This style should work.

Share this post


Link to post
Share on other sites
Firstly, the word 'SELECT' is to be used only once and all the columns to be displayed have to be comma separated instead of 'AND' and then the column names are not to have quotes

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.