can i join more than 3 table on phpmyadmin (mysql database).

Dwi Hyuga

10y1.1kSQL

i just wanna ask to you all who mastering SQL (specially on Xampp),

i am join more than 3 tables (4 tables) then i found my phpmyadmin not responding and could not refreshing it's page.

my query is like this

select a.*, b.*, c.*, d.kd_rol, d.no, e.no, from tbl_sticker AS a LEFT JOIN tbl_daftar_item AS b on a.KodeItem=b.KodeItem LEFT JOIN tbl_stickerhistory AS c ON (a.IDSticker=c.idsticker AND a.KodeItem=c.KodeItem AND a.keterangan=c.keterangan) LEFT JOIN 0_cfb AS d on a.KdBrg=d.kd_rol a.stsDel='F'

but, no error messege shown and no data displayed..

help me...

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dwi Hyuga10y ago
before the highlight code sould "where" code. but nothing happen
0
Pankaj Kumar Choudhary10y ago
Hello! Dwi your syntax for applying multiple join is correct. if you are not getting any result and warning then may be possible that there is some logical mistake .
select a.*, b.*, c.*, d.kd_rol, d.no, e.no, from tbl_sticker AS a LEFT JOIN tbl_daftar_item AS b on a.KodeItem=b.KodeItem LEFT JOIN tbl_stickerhistory AS c ON (a.IDSticker=c.idsticker AND a.KodeItem=c.KodeItem AND a.keterangan=c.keterangan) LEFT JOIN 0_cfb AS d on a.KdBrg=d.kd_rol a.stsDel='F'
can you tell that what is roll of highlighted code
0