关于Mysql的一个查询问题
Re关于Mysql的一个查询问题
试试这样是否可以
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
赞0
踩0