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
Questions on Database Administrators Stack Exchange are expected to relate to database administration within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.
if you are using any query and it throws an error please describe your error...