Please help me to slove this SQL statements

From: "Freshman" <abc(at)msn(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Please help me to slove this SQL statements
Date: 2003-10-30 12:38:14
Message-ID: bnr0nj$1173$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

There are three table in database which is suppliers, projects, and
shipments
suppliers contain suppliers id, name ...etc
projects contain project name ..suppliers ID ( J1---J7) ...etc
shipments table contain suppliers ID , PROJECTS ID

how can i query to find out the suppliers to supply all the projects ID

Browse pgsql-sql by date

  From Date Subject
Next Message 2000info 2003-10-30 13:35:36 psqlODBC with SSL
Previous Message Michele Bendazzoli 2003-10-30 12:35:34 Bug in Rule+Foreing key constrain?