By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| dnumber | dlocation |
|---|---|
| 1 | Houston |
| 4 | Stafford |
| 5 | Bellaire |
| 5 | Sugarland |
| 5 | Houston |
| 1 | Ankara |
7 rows affected
| pname | pnumber | plocation | dnum |
|---|---|---|---|
| ProductX | 1 | Bellaire | 5 |
| ProductY | 2 | Sugarland | 5 |
| ProductZ | 3 | Houston | 5 |
| Computerization | 10 | Stafford | 4 |
| Reorganization | 20 | Houston | 1 |
| Newbenefits | 30 | Stafford | 4 |
| Geomatics | 99 | Ankara | 1 |
| pnumber | pname | plocation | deptlocations |
|---|---|---|---|
| 1 | ProductX | Bellaire | Sugarland,Houston |
| 2 | ProductY | Sugarland | Bellaire,Houston |
| 3 | ProductZ | Houston | Bellaire,Sugarland |
| 20 | Reorganization | Houston | Ankara |
| 99 | Geomatics | Ankara | Houston |