I couldn't compile this little query (needs 2 tables)(mysql) 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
select f.friendid 
from friends f  
  inner join user u 
    on u.userid = f.userid 
where u.country='usa'