W1 (Working Group Exercise 1.) Date. 18.sept.03

Repeat the exercise from 2002. 
In addtion, perform the following "select" statements on my tables. 
In response: 
1. Show the results and explain the difference in the 3 results.
2. Write a "select" statement that uses a "self join" and show the results.
3. Write a "select" statement that uses a "join" from your tables. 
4. Put all results in a text file on your web site and send me a pointer (url) to the file.



select fname 
from employee, project
where employee.dno = project.dnum
and dno = '1';


select distinct fname 
from employee, project
where employee.dno = project.dnum
and dno = '1';


select distinct fname, pnumber
from employee, project
where employee.dno = project.dnum
and dno = '1';