请使用以下查询：

SELECT MAX(cnt.countnumber), cnt.postid
FROM counttbl as cnt
JOIN post as pst ON cnt.postid = pst.id

我给出了表名：
表名： post and counttbl

这句话会给你想要的结果。我将表和字段命名为differen，因为可能与sql中的保留字冲突。

SELECT * FROM 
(
  SELECT counts.postid, counts.counts 
  FROM counts 
  WHERE counts.counts = (SELECT max(counts) FROM counts) 
) tempcounts 
INNER JOIN posts ON posts.postid = tempcounts.postid 
ORDER BY posts.postdate DESC limit 0,1

如果更多的职位有相同的计数，他们都将在结果中

你可以在下面试试

select * from posts p 
inner join 
(
  select postid, max(countnumber) from counttbl group by postid
) as p1
on p.postid=p1.postid

试试这个：

select * from post where postid in (select postid from counttbl having max(countnumber));

试试这个
从post\u id所在的posts中选择*from posts（从countble中选择max（countnumber））