Answers


Quiz

A1:

a

A2:

c

A3:

b

A4:

d

A5:

c


Exercises

A1:
 select name , skill from employee, employeeSkills where employee.employeeID = employeeSkills.employeeID; 
A2:
 select client.clientID, name from client left join assignment on client.clientID = assignment.clientID where employeeID is NULL; 
A3:
 select clientID, name from client where not exists (select * from assignment where assignment.clientID = client.clientID); 



MySQL Tutorial
MySQL Tutorial
ISBN: 0672325845
EAN: 2147483647
Year: 2003
Pages: 261

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net