SELECT 单号,账号,[产品1] as 产品,[数量1] as 数量, [金额1] as 金额,VAL(金额1)*VAL(数量1) as 总计
FROM 单号产品 WHERE 产品1<>''order by 单号
UNION ALL
SELECT 单号,账号,[产品2] as 产品,[数量2] as 数量,[金额2] as 金额, VAL(金额2)*VAL(数量2) as 总计
FROM 单号产品 WHERE 产品2<>''order by 单号
UNION ALL
SELECT 单号,账号,[产品3] as 产品,[数量3] as 数量, [金额3] as 金额,VAL(金额3)*VAL(数量3) as 总计
FROM 单号产品 WHERE 产品3<>''
UNION ALL
SELECT 单号,账号,[产品4] as 产品,[数量4] as 数量, [金额4] as 金额,VAL(金额4)*VAL(数量4) as 总计
FROM 单号产品 WHERE 产品4<>''order by 单号
UNION ALL
SELECT 单号,账号,[产品5] as 产品,[数量5] as 数量,[金额5] as 金额, VAL(金额5)*VAL(数量5) as 总计
FROM 单号产品 WHERE 产品5<>''order by 单号
UNION ALL SELECT 单号,账号,[产品6] as 产品,[数量6] as 数量, [金额6] as 金额,VAL(金额6)*VAL(数量6) as 总计
FROM 单号产品 WHERE 产品6<>''
ORDER BY 单号;
点击下载此附件