coding


SELECT tb_biodata.nama_lengkap as nama, tb_biodata.jenis_pegawai, tb_biodata.cabang, tb_penilaian.tanggal,

                                   

case when tb_user.grup = 'satu' and tb_user.jabatan = 'kepegawaian' then rata_rata end  AS penilai1,


case when tb_user.grup = 'satu' and tb_user.jabatan = 'mg' then rata_rata end  AS penilai2,


case when tb_user.cabang = 'Majapahit 605' and tb_user.jabatan = 'amg' then rata_rata end  AS penilai3


FROM tb_biodata inner join tb_penilaian ON tb_biodata.kode_biodata = tb_penilaian.kode_biodata inner


join tb_user ON tb_penilaian.kode_user = tb_user.kode_user where tb_biodata.jenis_pegawai = 'pegawai kependidikan'


itu biar data nya satu baris gimana gan