ga ngerti persisnya yang dimaksut lucky gimana.
nebak2 aja, tapi barangkali query ini bisa ngebantu :
SELECT a.nama as Jurusan, b.nama as Pelajaran,
IFNULL(c.nilai, '0') as Nilai, IFNULL(d.nama,'-') as
Siswa FROM kategori a
LEFT JOIN skill b ON a.id=b.kategori
LEFT JOIN siswa_skill c ON b.kategori=c.skill
LEFT JOIN siswa d ON c.siswa=d.id
atau :
SELECT a.nama as Jurusan, b.nama as Pelajaran,
IFNULL(c.nilai, '0') as Nilai, IFNULL(d.nama,'-') as
Siswa FROM kategori a
LEFT JOIN skill b ON a.id=b.kategori
LEFT JOIN siswa_skill c ON b.kategori=c.skill
LEFT JOIN siswa d ON c.siswa=d.id
WHERE (a.id=b.kategori) && (b.kategori=c.skill) &&
(c.siswa=d.id)
CMIIW
--- Natali Ardianto <[EMAIL PROTECTED]> wrote:
> Huehehe Steven aj bingung apalagi gwe :P~
>
> Btw, buat lucky, kl mau pakai subquery, tapi keknya
> mysql masih ndak
> sempurna. Yah di loop aj querynya melalui
> programmingnya.. beres.
>
>
> On 8/2/05, Steven Haryanto <[EMAIL PROTECTED]>
> wrote:
> > pakek kurung gimana sih maksudnya? sintaks SQL ya
> begitu, kalo ingin
> > JOIN ya tambah klausa JOIN di belakangnya:
>
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12hls6ee4/M=362329.6886308.7839368.1510227/D=groups/S=1705005512:TM/Y=YAHOO/EXP=1123045401/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992
">Fair play? Video games influencing politics. Click and talk back!</a>.</font>
--------------------------------------------------------------------~->
----------------------------------------------------------
Komunitas MasterWeb Indonesia http://www.master.web.id
----------------------------------------------------------
MWN, Masternya WEBHOSTING di Indonesia, Indo/USA Servers,
Customer Support 24 jam http://www.masterwebnet.com
----------------------------------------------------------
WebDevelopment,Designing/Programming http://www.dlanet.com
----------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/milis-masterweb/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
