List:General Discussion« Previous MessageNext Message »
From:gregor gede Date:July 26 2002 2:23am
Subject:inner join query don't work
View as plain text  
hi what's wrong with this query? is it because mysql
doesn't support multiple table selection? I use

SELECT Buku.Judul_Buku, Buku.ISBN, Buku.Kolasi,
Buku.Abstraksi, Pengarang.Pengarang,
Penerbit.Penerbit, Jenis_Buku.Jenis, Subjek.Subjek 
FROM Buku, Pengarang_Buku, Pengarang, Penerbit,
Jenis_Buku, Subjek_Buku, Subjek 
WHERE Buku.ID_Buku = Pengarang_Buku.ID_Buku and
Pengarang_Buku.No_Pengarang = Pengarang.No_Pengarang
and  Buku.No_Penerbit = Penerbit.No_Penerbit and
Buku.No_Jenis_Buku = Jenis_Buku.No_Jenis_Buku and
Buku.ID_Buku = Subjek_Buku.ID_Buku and
Subjek_Buku.No_Subjek = Subjek.No_Subjek and
Buku.Judul_Buku like  '%pascal%' and
Pengarang.Pengarang like '%$lukito%' and Subjek.Subjek
like '%$computer%'

than's a lot.

Do You Yahoo!?
Yahoo! Health - Feel better, live better
inner join query don't workgregor gede26 Jul
  • Re: inner join query don't workRalf Narozny26 Jul
  • Re: inner join query don't workDiana Soares26 Jul