From: Andrew Mather (Powered By Linux) <mathera@woody.agvic.gov.au>
To: pgsql-novice@postgreSQL.org
To: pgsql-sql@postgreSQL.org
Subject: SQL help
Date: Sat, 7 Nov 1998 22:55:16 +0000
Message-ID: <103D75BA54B5@woody.agvic.gov.au> (raw)
G'day All,
I'm having a bit of trouble with a couple of SQL statements and hope
someone can help.
Firstly can postgresql handle JOINs ? I can't seem to find anything
about it.
more importantly:
I have a small db set up as follows:
EMPLOYEES
employee_id
name
address
salary
PROJECTS
project_id
project_name
project_location
WORKS_ON
employee_id
project_id
job
rating
I need to find:
All employees who work on every project.
(easy enough to find all who work on any particular project, but not
those who work on EVERY project)
distinct employees whose salary is higher than their managers.
Thanks in anticipation
Andrew
--------------------------------------------------------
Andrew Mather: System Administrator, VIAS
mathera@woody.agvic.gov.au / amsm@deakin.edu.au
http://www.deakin.edu.au/~amsm/index.html
Ph: 03 92174342 (BH), Mob 0413 009 761
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
All I need is a Wave and a board to surf it on.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--=-=-
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mathera@woody.agvic.gov.au, pgsql-novice@postgreSQL.org
Subject: Re: SQL help
In-Reply-To: <103D75BA54B5@woody.agvic.gov.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox