TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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...
Reply
Answers (
2
)
Is it possible when i want to join data from 2 databases?
problem face inserting urdu word