could someone help me to merge these two queries together, I can't by myself.
Getting the Topics
Code: Select all
SELECT
t.*,
m.*,
UNIX_TIMESTAMP(t.topic_time) as 'timestamp'
FROM
topics AS t,
members AS m
WHERE
t.topic_uid = m.member_idCode: Select all
SELECT *, MAX(post_time) AS newest FROM posts GROUP BY post_tidThanks in advance for any input!