how to join Between four tables on mysql -
i have 4 tables mysql database, how join between them users: userid|username 1 | mark 2 | jon awards_user : awardid|userid 1 |1 2 |2 cat : catid|catname 1 | english 2 | computer awards : awardid|catid|awardname|awardlink 1 |1 |best1 |pic link 2 |2 |best2 |pic link resulte : userid|username|catid|catname|awardid|awardname|awardlink okay , try : works shows 1 result, when there member holds award ، want show awards, if there no 1 holds them . $all_awards = $db->query_read(" select * " . table_prefix . " users,awards_user,cat,awards awards_user.awardid = awards.awardid , awards_user.userid = users.userid , awards.catid = cat.catid "); create table `awards` ( `id` int(10) unsigned not null auto_increment, `forumid` int(10) unsigned not null, `name` varchar(100) not null default '', `link` varchar(100) not null default '', primary key (`id`) ) engine=my...