Query Like

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 like '%2012/2013%' and b.smester like '%satu%' group by a.nis=b.nis