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

Question

I have a two different tables

Table 1
id
name
description

Table 2
id 
details
info
table1_id

I want to display all the records from the table1 except id but from table2 I used to display the max id.

eg. table1 have following records

id=1
name = test
description = some text

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

so the result what I want is

id  name   description
5   test   some text

Answer 1

Try this:

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

or left join:

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