Advertisement
Guest User

Untitled

a guest
Dec 3rd, 2019
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.45 KB | None | 0 0
  1. $query2 = "SELECT output_kinerja.output, output_kinerja.bobot, input_penilaian.tanggal_input, output_kinerja.bobot*SUM(nilai_target) AS nilaitotal, bobot, output, SUM(nilai_target) AS nilaijumlah FROM input_penilaian JOIN output_kinerja ON input_penilaian.id_out=output_kinerja.id_out WHERE MONTH(tanggal_input)='".$_GET['bulan']."' AND YEAR(tanggal_input)='".$_GET['tahun']."' AND input_penilaian.id_in='$id_in' AND id='$id' GROUP BY output_kinerja.id_out";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement