我正在嘗試從三個(gè)表中獲取數(shù)據(jù)。表名桌上溫泉表spa_meta表庫(kù)存（使用簡(jiǎn)單連接，庫(kù)存僅返回一列unit_no，這不是問(wèn)題）表的數(shù)據(jù)結(jié)構(gòu)如下桌上溫泉表Spa_meta我想列出基本信息應(yīng)該來(lái)自First table Spa的數(shù)據(jù)（id，title，inventory_id）但是在其他表spa_meta中，只能選擇一個(gè)條目，其spa_id匹配項(xiàng)應(yīng)根據(jù)created_at列（時(shí)間）為DESC問(wèn)題：如何使用最少的SQL查詢來(lái)實(shí)現(xiàn)這一點(diǎn)。當(dāng)我正在嘗試這顯然是錯(cuò)誤的 select *, inventory_id, max(created_at) as MaxDate, inventory.unit_no as unitfrom spa_meta tinner join (    select spa.id as id, spa.title, spa.inventory_id as inventory_id,     from spa     group by spa.id ) tm on t.spa_id = tm.id left join inventory  on tm.inventory_id = inventory.idgroup by unit order by MaxDate DESC