Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> newbie question
Hello netters,
I have a newbie question to ask, hopefully someone can help me.
I have the following relations and entity tables:
employees(ename,ssn,address) key: (ssn) departments(dname,did,mgr_ssn) key: (did) works_on(ssn,pno,hours) key: (ssn,pno) projects(pname,pno,did) key: (pno) dependencies(ssn,depname,age,relationship) key:(ssn,depname)
I need to create SQL statements for the following queries:
I am very new to SQL and have problems creating queries for the above. Hopefully some smart folks out there can help me.
Thanks in advance,
Nick
Received on Mon Nov 02 1998 - 15:01:53 CST