SELECT id_jadwal, a.nama_tim tim1, b.nama_tim tim2 FROM jadwal INNER JOIN tim a ON jadwal.tim1 = a.id_tim INNER JOIN tim b ON jadwal.tim2 = b.id_tim :cendolbig:cendolbig:cendolbig