//Multiple Froms
Showing rows 0 - 13 (14 total, Query took 0.0011 sec)
SQL query:
SELECT forums_topics.cTitle, forums_topics.cContent AS forumContent, forums_replys.iReplyID, forums_replys.cContent AS replyContent, users.cUsername
FROM forums_topics, forums_replys, users
WHERE forums_topics.iTopicID =4
AND forums_replys.iPosterID =1
LIMIT 0 , 30 

//Joins
Showing rows 0 - 0 (1 total, Query took 0.0876 sec)
SQL query:
SELECT forums_replys.iReplyID, forums_replys.cContent AS replyContent, forums_topics.cTitle, forums_topics.cContent AS topicContent, users.cUsername
FROM forums_replys
LEFT JOIN forums_topics ON forums_replys.iTopicID = forums_topics.iTopicID
LEFT JOIN users ON forums_replys.iPosterID = users.iUserID
WHERE forums_replys.iTopicID =4
AND forums_replys.iPosterID =1
LIMIT 0 , 30