Open this image
我试着问,为什么不能一个技术而已?
SELECT a.kode_ticket,a.tanggalbuat_ticket,a.tanggalapprove_ticket,a.tanggalfinish,b.nama_karyawan AS nama_lapor,c.nama_karyawan AS nama_teknisi,a.subject_ticket,a.detail_ticket,a.status_ticket,a.progress_ticket FROM ticket AS a JOIN karyawan AS b ON a.pelapor_ticket=b.nik_karyawan JOIN karyawan AS c ON a.teknisi_ticket=c.nik_karyawan WHERE a.teknisi_ticket = '3603191601000002' AND a.status_ticket = 'Approved' || a.status_ticket = 'Progress'
这样地
kode|u票| tanggalbuat|u票| tanggalapprove|u票| tanggalfinish | nama_lapor | nama_teknisi | subject| detail| status| progress|u票
0000000 | 20000000 | 10000000 | 5000000 | Romali Naibaho | Muklis 2 | blabla | blabla |进度| 20
