Need help on SQL problem..

From: Evelyn <onezero_at_post1.com>
Date: Sat, 18 Sep 1999 01:31:27 +1000
Message-ID: <37e25fb7@news.ausmail.com>

Hi all,

First of all, thank you for taking time to read my posting. I'm a = newbies in Oracle SQL and now i'm stuck with this particular problem, i = really appreaciate you can help me on this. Thanks in advance..

I have 3 tables, and my problem is, i need to find the names of the = employee who works on every projects?

Employee     (fname, lname, ssn) -> ssn is the primary key
Project         (pname, pnumber, plocation, deptnum) -> pnumber (project =
no) is the primary key
Works_on     (essn, pno, hours) -> essn (same as Employee's ssn) + pno =

(same as Project's pnumber) is the primary key

I thank you for helping me on this problem. Thanks a zillion!!

--
Cheers
Evelyn
17 Sept'99 Received on Fri Sep 17 1999 - 10:31:27 CDT