项目表数据表结构及值:
ID 项目
1 长
2 宽
3 高
4 材质
项目值数据表结构及值:
ID 项目ID 项目值
1 1 1200
2 1 1300
3 1 1250
4 1 980
5 2 850
6 2 750
7 2 650
8 3 400
9 3 500
10 3 600
11 3 700
12 3 800
13 4 ABS
14 4 Q235
程序计算出效果: 长:1200_宽:850_高:400_材质:ABS
…
...
ID 项目
1 长
2 宽
3 高
4 材质
项目值数据表结构及值:
ID 项目ID 项目值
1 1 1200
2 1 1300
3 1 1250
4 1 980
5 2 850
6 2 750
7 2 650
8 3 400
9 3 500
10 3 600
11 3 700
12 3 800
13 4 ABS
14 4 Q235
程序计算出效果: 长:1200_宽:850_高:400_材质:ABS
…
...
1200 850 400 ABS
1300 750 500 Q235
1250 650 600
980 700
800
--顺便说一句,楼主定义是否有问题,第二张表你只给出了两个字段,是否还缺少一个字段,这些属性归属于哪个物件?
WITH tb AS
( SELECT 1 AS itemid, '长' AS proid, '1200' AS project FROM dual
UNION
SELECT 2, '长', '1300' FROM dual
UNION
SELECT 3, '长', '1250' FROM dual
UNION
SELECT 4, '长', '980' FROM dual
UNION
SELECT 1, '宽', '850' FROM dual
UNION
SELECT 2, '宽', '750' FROM dual
UNION
SELECT 3, '宽', '650' FROM dual
UNION
SELECT 1, '高', '400' FROM dual
UNION
SELECT 2, '高', '500' FROM dual
UNION
SELECT 3, '高', '600' FROM dual
UNION
SELECT 4, '高', '700' FROM dual
UNION
SELECT 5, '高', '800' FROM dual
UNION
SELECT 1, '材质', 'ABS' FROM dual
UNION
SELECT 2, '材质', 'Q235' FROM dual
)
SELECT itemid,wm_concat(proid || ':' || project) as itemDesc FROM tb GROUP BY itemid--结果
ITEMID ITEMDESC
---------------------- ------------------------------
1 材质:ABS,宽:850,高:400,长:1200
2 材质:Q235,宽:750,高:500,长:1300
3 长:1250,宽:650,高:600
4 长:980,高:700
5 高:800