
------解决思路----------------------
select t1.*,t2.Title
from Customer t1,Organization t2
where t1.Organization=t2.ID
上面是内连接,可以根据实际情况改成left join。
------解决思路----------------------
select t1.Name,t1.Mobile,,t2.Title as Organization
from Customer t1,Organization t2
where t1.Organization=t2.ID