Pls help me guys.
what's wrong with this command ? select a.siswa_id,a.nama,b.Nilai from Query_DataSiswa a left join ( select siswa_id,Nilai,Tes_Id from Nilai_Harian where tes_id = 1 and pertemuan = 1 and paket_id = 1 and tingkat = 1) b on a.siswa_id = b.siswa_id where a.paket_id = 1 and a.Tingkat = 1 order by a.siswa_id I've got error if I execute it. pls check the mysql version for this command ? thanks --------------------------------- Do you Yahoo!? The New Yahoo! Shopping - with improved product search