php - 从两个具有id的表中检索数据并显示Mysql中另一个表的最大id

Question

我有两个不同的表

Table 1
id
name
description

Table 2
id 
details
info
table1_id

我想显示 table1 中除 id 之外的所有记录，但 table2 中我用来显示最大 id.

例如。 table1 有以下记录

id=1
name = test
description = some text

table2 have
id=5
details = some more text
info = the new info
table1_id = 1

所以我想要的结果是

id  name   description
5   test   some text

Answer 1

试试这个:

select
    (select max(table2.id) from table2 where table1.id = table2.table1_id) id,
    name,
    description
from table1

或左连接:

select
    t.id,
    table1.name,
    table1.description
from table1
left join (
    select max(id) id, table1_id from table2 group by table1_id
) t on table1.id = t.table1_id