SQL Join only returning 1 row.

Posted by kevin on Stack Overflow See other posts from Stack Overflow or by kevin
Published on 2011-01-08T23:45:14Z Indexed on 2011/01/08 23:54 UTC
Read the original article Hit count: 135

Filed under:
|

Not quite sure what I'm missing, but my SQL statement is only returning one row.

  SELECT 
    tl.*, 
    (tl.topic_total_rating/tl.topic_rates) as topic_rating, 
    COUNT(pl.post_id) - 1 as reply_count, 
    MIN(pl.post_time) AS topic_time, 
    MAX(pl.post_time) AS topic_bump 
  FROM topic_list tl 
    JOIN post_list pl 
      ON tl.topic_id=pl.post_parent 
    WHERE 
      tl.topic_board_link = %i 
      AND topic_hidden != 1 
    ORDER BY %s

I have two tables (post_list and topic_list), and post_list's post_parent links to a topic_list's topic_id.

Instead of returning all the topics (where their board's topic_board_link is n), it only returns one topic.

© Stack Overflow or respective owner

Related posts about mysql

Related posts about join