Query

select * from tsiswa as a,tnilai as b where b.nama_kelas='1N1' or b.id_guru='4' or b.id_pelajaran='9' or b.tahun_ajaran="2012/2013" or b.smester='satu' group by a.nis=b.nis