I couldn't compile this little query (needs 2 tables)(mysql) [closed]

Question

i have 2 tables as like seen :

user table : id, userid , country

friends table : id, userid , friendid

so i want to get friendid rows from friends table where friends.userid == user.userid and user.country='USA' ?

thanks for your helps

there is no error i say i couldnt compile the right query : ) and friendids should be unique ?

Gaurav Agrawal · Accepted Answer · 2012-04-09 11:23:07Z

up vote 0 down vote accepted

select f.friendid from friends f, user u where u.userid = f.userid and u.country = 'usa';

if you are using any query and it throws an error please describe your error...

answered Apr 9 '12 at 11:23

Gaurav Agrawal
1242

Do not teach people to use SQl antipatterns like implicit joins. – HLGEM May 18 '12 at 13:22

ypercube · Answer 2 · 2012-05-18 08:39:42Z

up vote 2 down vote

select f.friendid 
from friends f  
  inner join user u 
    on u.userid = f.userid 
where u.country='usa'

edited May 18 '12 at 8:39

ypercube
8,74921544

answered May 18 '12 at 7:33

swapna
212

closed as off topic by Jack Douglas♦ May 18 '12 at 21:11