ini q copy perintah dr report query


SELECT
detailkal.`Kodea` AS detailkal_Kodea,
detailkal.`Type` AS detailkal_Type,
tpe.`Nomor` AS tpe_Nomor,
tpe.`Kodea` AS tpe_Kodea,
tpe.`Alat` AS tpe_Alat,
tpe.`tarif` AS tpe_tarif,
tpe.`Jumlah` AS tpe_Jumlah,
tpe.`Total_Biaya` AS tpe_Total_Biaya,
tpek.`Nomor` AS tpek_Nomor,
tpek.`ID_Permintaan` AS tpek_ID_Permintaan,
tpek.`Nama_Pemohon` AS tpek_Nama_Pemohon,
tpek.`No_Telpon` AS tpek_No_Telpon,
tpek.`Alamat` AS tpek_Alamat,
tpek.`Total_Biaya` AS tpek_Total_Biaya,
tpek.`Tanggal` AS tpek_Tanggal,
detailkal.`Nomor` AS detailkal_Nomor
FROM
`detailkal` detailkal,
`tpe` tpe,
`tpek` tpek
WHERE
tpek.`Nomor` = tpe.Nomor
AND tpek.`Nomor` = detailkal.Nomor
AND tpe.`Kodea` = detailkal.Kodea;

dan begini hasil nya


pertanyaan sy

bagimana buat agar
data nya gk duplicat krna dst ada colom tipe NYA beda
dan hrs di mnculkan dan mau gk mw pasti data nya ikut terduplikat :/

pls help ya