GROUP_CONCAT

最新推荐文章于 2023-06-23 00:10:13 发布

牧濑红莉栖丶丶

最新推荐文章于 2023-06-23 00:10:13 发布

阅读量204

点赞数

本文链接：https://blog.csdn.net/qq_36500199/article/details/80842666

版权

SELECT
	@rownum :=@rownum + 1 rowNum,p.varStandardName,s.varName station,vl.varLevelName,c.varName,c.numCircuitID,p.douStandardValue,p.douSysStandardValue,pd.varDataPointName,GROUP_CONCAT(l.varColName SEPARATOR ',')
FROM
	(SELECT @rownum := 0) b,WD_PowerQuanlityStandard p
LEFT JOIN WD_VoltageLevel vl ON vl.numLevelID = p.numLevelID
LEFT JOIN WD_PQStandardDataPoint pd ON pd.numDataPoint = p.numDataPoint
LEFT JOIN WD_CircuitRefPowerQuanlityStandard crq ON crq.numStandardID = p.numStandardID
LEFT JOIN WD_Circuit c ON c.numCircuitID = crq.numCircuitID
LEFT JOIN WD_SubStation s ON s.numStationID = c.numStationID
LEFT JOIN WD_LoadDirectory l on p.numDataPoint = l.numDataPoint
WHERE p.varStandardType = 0 GROUP BY p.numStandardID