SELECT A.颜色号 , B.颜色 AS 主1 , C.颜色 AS 主2 , D.颜色 AS 内 , E.颜色 AS 网 , F.颜色 AS 拉 FROM TT AS A LEFT JOIN TT AS B ON B.颜色号 = A.颜色号 AND B.形式 = '主1' LEFT JOIN TT AS C ON C.颜色号 = A.颜色号 AND C.形式 = '主2' LEFT JOIN TT AS D ON D.颜色号 = A.颜色号 AND D.形式 = '内' LEFT JOIN TT AS E ON E.颜色号 = A.颜色号 AND E.形式 = '网' LEFT JOIN TT AS F ON F.颜色号 = A.颜色号 AND F.形式 = '拉' GROUP BY A.颜色号 , B.颜色 , C.颜色 , D.颜色 , E.颜色 , F.颜色