暂无个人介绍
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
-------------------------
-------------------------