SELECT tbl_users.* --Choose desired fields ,tbl_comments.* --Choose desired fields FROM tbl_users INNER JOIN tbl_comments ON tbl_comments.user_id = tbl_users.user_id WHERE tbl_comments.thread_id = 110
SELECT C.*, U.user_total_posts, U.user_total_threads FROM tbl_comments AS C LEFT OUTER JOIN tbl_users AS U ON C.user_id = U.user_id WHERE C.thread_id=110
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)