A LEFT JOIN B

Search
A left join B
id
name
id 1
name 1
1
1
null
null
2
2
2
AAA