擅长:python、mysql、java
<p>也许是这样的?你知道吗</p>
<pre><code>SELECT * FROM
multipliers INNER JOIN pushes
ON multipliers.push_id = pushes.push_id
ORDER BY multipliers.push_id DESC
LIMIT 1
</code></pre>
<p><code>INNER JOIN</code>确保您正在从<code>multiplier</code>中选择数据,该<code>push</code>记录的数据集按最大的<code>push_id</code>排序。你知道吗</p>
<p>根据您的意见,有关“推送类型”的其他标准,您可以使用:</p>
<pre><code>SELECT * FROM
multipliers INNER JOIN pushes
ON multipliers.push_id = pushes.push_id
WHERE pushes.type = 'X'
ORDER BY multipliers.push_id DESC
LIMIT 1
</code></pre>
<p/><hr/>
<h3>编辑:</h3>
<p>更新问题后,您可能需要执行以下操作:</p>
<pre><code>select m.*, p.type
from multipliers m inner join pushes p on m.push_id = p.id
where m.push_id =
(
select max(m2.push_id)
from multipliers m2 inner join pushes p2 on m2.push_id = p2.id
where p2.type = 'CONSTANT'
)
</code></pre>