SELECT
ID,
(SELECT
Property_Name
FROM
table2 t2
WHERE t1.PropertyID1 = t2.PropertyID) AS Property_Name1,
(SELECT
Property_Name
FROM
table2
WHERE t1.PropertyID1 = t2.PropertyID) AS Property_Name2,
(SELECT
Property_Name
FROM
table2
WHERE t1.PropertyID1 = t2.PropertyID) AS Property_Name3,
Content
FROM
table1 t1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货