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.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--=-=-