Exercises


1:

Write a query that lists an employee's name and all her skills.

2:

Write a query using a LEFT JOIN that lists clients who have not had any employees working for them on assignment.

3:

Rewrite your query from exercise #2 to use EXISTS .




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