mysql表一对一查询

image.png

select houses.id as 房屋编号, houses.address as 房屋地址, owner.custname as 租户姓名
from houses, owner
where houses.owner_id = owner.id;