Select statement.
The following tables are used to demonstrate examples of Select SQL statement.
| STAFF |
PTASK |
ACTIVITY |
| ID | NAME | POSITION |
| 1 | Sam | tester |
| 2 | Tom | developer |
| 3 | Bill | developer |
| 4 | Frank | db_admin |
| 5 | Mary | designer |
| 6 | Ann | tech.writer |
| 7 | John | developer |
|
| ID | NAME | ST | TSTART | TFINISH |
| 1 | System Prototype | D | 01.10.06 | 12.10.06 |
| 2 | Core Functions | D | 14.10.06 | 28.10.06 |
| 3 | DB Interface | D | 17.10.06 | 25.10.06 |
| 4 | User Interface | P | 12.10.06 | 18.10.06 |
| 5 | App Server | U | 27.10.06 | null |
| 6 | App Client | U | 25.10.06 | null |
| 7 | Stress Testing | U | null | null |
| 8 | Manuals | U | null | null |
|
| ID_T | ID_S | TSTART | TFINISH |
| 1 | 7 | 01.10.06 | 12.10.06 |
| 2 | 3 | 14.10.06 | 28.10.06 |
| 3 | 4 | 17.10.06 | 25.10.06 |
| 4 | 2 | 12.10.06 | 18.10.06 |
| 4 | 5 | 16.10.06 | 18.10.06 |
| 6 | 2 | 25.10.06 | null |
| 5 | 7 | 27.10.06 | null |
| 6 | 5 | 28.10.06 | 30.10.06 |
| 5 | 4 | 29.10.06 | 30.10.06 |
| 5 | 1 | 01.11.06 | 03.11.06 |
| 5 | 3 | 02.11.06 | null |
| 6 | 6 | 03.11.06 | null |
|
