SQL joins

[Anon]

i have 2 tables

members and country

here are some records

members table

name |email | country

kalyan |[e-mail] | 1

country table

id | name

1 | USA

now my question how to pick up a record based on the term "USA" given in the search field

i need to have a SQL join where i should check for the "id" of USA first in the table country and then match that against the member table and pick up that record

what SQL queries should i use there
i need the SQL joins Query of 2 tables.

thanks in advance.

[Anon]

So, in plain English, you need to find:

All records of table member where:
-- country is USA

In Postgresql, you could use a subselect.

If you are using mysql (which doesn't support subselects), you'll have to do something more like this:
All records of table member and country where:
country.country_id matches member.country_id
AND
country.name is USA

SELECT * FROM members, country
WHERE
country.country_id=member.country_id AND
country.name='USA'

[[deleted]]

Wether you should use a subquery in postgreSQL is debatable, JOINs are often faster than subqueries.

[amesowe]

and in this particular case JOIN will work faster.