mysql 填充null,如果现有的else填充NULL，则MySQL JOIN行

I have two tables of peoples names and properties. Some have no entries yet and I would like to create a full list of all people and their properties (if available) else have them listed with property "NULL". That's my simplicified example:

names

id name

-------------

1 Jon

2 Peter

3 Sam

4 Bruce

...

properties

names_id property

--------------------

1 foo

3 bar

...

desired result:

id name property

------------------------

1 Jon foo

2 Peter NULL

3 Sam bar

4 Bruce NULL

...

Thank you!

解决方案

Here, using join:

select A.id, A.name, B.property

from table1 A

left outer join table2 B on A.id=B.names_id