SQL statement: SELECT firstName, lastName, projNo FROM Worker, Assign WHERE Worker.empId = Assign.empId;
There are 9 records in this query.
| First Name | Last Name | Project Number |
|---|---|---|
| Tom | Smith | 1001 |
| Mary | Jones | 1001 |
| Mary | Jones | 1005 |
| Jane | Burns | 1001 |
| Amanda | Chin | 1001 |
| Michael | Burns | 1019 |
| Amanda | Chin | 1019 |
| Michael | Burns | 1025 |
| Michael | Burns | 1030 |