我有两个表：
tickets
ticket_updates
我试图在那里显示了从票表数据和运行查询order by最新datetime的ticket_updates表
SELECT * from tickets where status = 'Completed' order by ??? DESC LIMIT 0,50
ticketnumber在tickets表中匹配ticketnumber在ticket_updates表中
SELECT t.*
FROM tickets AS t
JOIN ticket_updates AS tu ON t.ticketnumber = tu.ticketnumber
WHERE status = 'Completed'
ORDER BY tu.datetime DESC LIMIT 50
尝试这个。
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句