P.S. sample data is just a sample, your SQL statement should work for any data. table TECH_PERSONNEL pplSoft fname lname pittID expertise office_phone expYears supervisor ------- ------- ------- ------ --------------- ------------ -------- ---------- 1110001 Bob Hoffman bh1 Unix systems 412-624-8404 15 1110001 1110002 Terry Wood tw1 Hardware 412-624-8831 14 1110001 1110003 Russ Howard rh1 Windows Systems 412-624-8834 9 1110001 1110004 Christian Mason cm1 Web Technology 412-624-9181 5 1110001 TABLE USERS pplSoft fname lname pittID office phone ------- ------------ ----------- ------ ------------ 5550001 Shenoda Guirguis shg18 412-624-8443 5550002 Lory Almoakar la1 412-624-8443 5550003 Thao Pham tp1 412-624-8850 5550004 Michel Hanna mh1 412-624-8402 TABLE CATEGORIES category id category description ----------- --------------------- --------- ------------- ---------------------------- 01 Printing Problem problems have to do with printers and printing 02 Network Problem problems have to do with the network and/or internet 03 Windows OS problem problems have to do with Windows OS maintenance 04 Unix/Linux OS problem problems have to do with Unix/Linux OS maintenance 05 Hardware Problem HW maintenance issues 06 Software Problem SW maintenance issues 07 Server Problem Any problem has to do with the dept. servers 08 Software install Requests to install additional SW 09 Web Problem Any problem has to do with the dept. web sites 10 Windows Help Questions about Windows (hotline support) 11 Unix/Linux Help Questions about Unix/Linux (hotline support) 12 SW Help Questions about installed SW (hotline support) 13 AFS problem Problems related to the AFS system. TABLE LOCATIONS location_id location building notes ----------- --------- -------- ----------------------- 01 6th floor SENSQ db research lab 02 6th floor SENSQ os research lab 03 5th floor SENSQ arch research lab 04 6th floor SENSQ java lab 05 5th floor SENSQ reading room TABLE INVENTORY machine_name IP network_port MACADDR location_id ------------- ----------------- --------------- ------------------ ------------ acta.cs.pitt.edu 102.168.222.226 sq6-52 01:23:45:67:89:ab 01 kaly.cs.pitt.edu 102.168.222.227 sq5-14 01:23:45:67:89:ac 03 elements.cs.pitt.edu 102.168.222.228 sq5-23 01:23:45:67:89:ad 05 kaso.cs.pitt.edu 102.168.222.229 sq6-22 01:23:45:67:89:ae 02 oxgyn.cs.pitt.edu 102.168.212.216 sq5-17 01:23:45:67:89:af 03 rodi.cs.pitt.edu 102.168.212.217 sq6-51 01:23:45:67:89:ba 01 java lab machine 102.168.212.220 sq6-41 01:23:45:67:89:bb 04 TABLE TICKETS ticket_number owner_pplSoft date_submitted date_closed days_worked_on category_id machine_name description ------------- ------------- -------------- ----------- -------------- ----------- -------------------- ------------------------------------------------- 000000567841 5550001 20-DEC-15 28-DEC-15 9 05 acta.cs.pitt.edu The fan is noisy. 000000567842 5550002 20-DEC-15 22-DEC-15 3 01 kaly.cs.pitt.edu Can not print any PDF file! 000000567843 5550002 23-DEC-15 NULL NULL 06 elements.cs.pitt.edu Seems that the server is down?! 000000567844 5550001 28-DEC-15 31-DEC-15 4 06 acta.cs.pitt.edu The AFS client crashes all the time! 000000567845 5550003 01-JAN-16 05-JAN-16 5 04 kaso.cs.pitt.edu The mouse responds in a weird way. 000000567846 5550002 02-JAN-16 02-JAN-16 1 02 oxgyn.cs.pitt.edu can not connect to the oxgyn server! 000000567847 5550001 05-JAN-16 06-JAN-16 2 08 acta.cs.pitt.edu I failed to login to the evaluation site. 000000567848 5550003 05-JAN-16 12-JAN-16 8 07 kaso.cs.pitt.edu May I have SigmaPlot installed on my machine? 000000567849 5550003 13-JAN-16 NULL NULL 05 kaso.cs.pitt.edu Some keys on the keyboard does not function. 000000567850 5550004 14-JAN-16 NULL NULL 10 rodi.cs.pitt.edu The sound card is unrecognized. 000000567851 5550001 14-JAN-16 23-JAN-16 10 05 acta.cs.pitt.edu The harddrive got bad sector. 000000567852 5550003 14-JAN-16 17-JAN-16 4 03 kaso.cs.pitt.edu Windows crashed! 000000567853 5550003 15-JAN-16 21-JAN-16 7 12 kaso.cs.pitt.edu can not reach AFS-home directory from home. 000000567854 5550001 16-JAN-16 17-JAN-16 2 06 acta.cs.pitt.edu I have trouble configuring Outlook. 000000567855 5550003 20-JAN-16 NULL NULL 03 kaso.cs.pitt.edu Windows crashed! 000000567856 5550004 25-JAN-16 NULL NULL 08 java lab machine Can not submit my h/w using the submission site. TABLE ASSIGNMENT ticket_number tech_pplSoft date_assigned status outcome ------------- ------------ ------------- ----------------- ------- 000000567841 1110001 20-DEC-15 delegated NULL 000000567841 1110002 24-DEC-15 closed_successful NULL 000000567842 1110002 20-DEC-15 closed_successful NULL 000000567843 1110001 23-DEC-15 assigned NULL 000000567844 1110003 28-DEC-15 closed_successful NULL 000000567845 1110003 01-JAN-16 closed_successful NULL 000000567846 1110002 02-JAN-16 closed_successful NULL 000000567847 1110001 05-JAN-16 closed_successful NULL 000000567848 1110003 05-JAN-16 delegated NULL 000000567848 1110001 08-JAN-16 closed_successful NULL 000000567849 1110003 13-JAN-16 in_progress NULL 000000567850 1110004 14-JAN-16 in_progress NULL 000000567851 1110001 14-JAN-16 delegated NULL 000000567851 1110002 20-JAN-16 closed_successful NULL 000000567852 1110003 14-JAN-16 closed_successful NULL 000000567853 1110003 15-JAN-16 delegated NULL 000000567853 1110001 18-JAN-16 closed_successful NULL 000000567854 1110001 16-JAN-16 closed_successful NULL 000000567855 1110001 20-JAN-16 assigned NULL 000000567856 1110003 25-JAN-16 delegated NULL 000000567856 1110004 27-JAN-16 assigned NULL