Comments: Authenticated sender is <mathera@woody.agvic.gov.au>
From: "Andrew Mather (Powered By Linux)" <mathera@woody.agvic.gov.au>
Organization: COMPLETE LACK OF
To: pgsql-novice@postgreSQL.org, pgsql-sql@postgreSQL.org
Date: Sat, 7 Nov 1998 22:55:16 +0000
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Subject: SQL help
Reply-to: mathera@woody.agvic.gov.au
Priority: normal
Message-ID: <103D75BA54B5@woody.agvic.gov.au>

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.   

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--=-=-