Dwi Hyuga

Dwi Hyuga

  • NA
  • 116
  • 21.6k

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

Jan 15 2016 1:38 AM
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... 

Answers (2)