From: "garhone" <cacheung@consumercontact.com>
Subject: SELECT on a to-be-determined table
Date: 14 Feb 2006 07:28:30 -0800
Organization: http://groups.google.com
Lines: 43
Message-ID: <1139930910.624290.83370@g44g2000cwa.googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: g44g2000cwa.googlegroups.com; posting-host=209.167.202.14;
	posting-account=xbiNWA0AAAATcpeB_WPmKiETyj6063eZ
To: pgsql-sql@postgresql.org

Hi,

I'm a new at this. So please forgive if I mess up. Also, if there is
already a reference/tutorial somewhere, feel free to point me to it.

Here's my situation:
db=# select * from projects;
 projid | projname
--------+----------
      1 | cars
      2 | houses
      3 | pets
(3 rows)

db=# select * from cars;
 carid | carname
-------+---------
     1 | ford
     2 | mazda
(2 rows)

db=# select * from houses;
 houseid | housename
---------+-----------
       1 | semi
       2 | trailer
       3 | mansion
(3 rows)

db=# select * from pets;
 petid | petname
-------+---------
     1 | dog
     2 | cat
     3 | bird
(3 rows)

Is it possible to do this:
Give me all the rows of the table whose project id is 2 (or whatever
projid).

Thanks