此主题相关图片如下:d930a44b-b12a-4d25-828c-48cd191e8346.png
当sizebi非空的时候 size1作为文胸尺码明细_65,size2作为文胸尺码明细_70,size3作为文胸尺码明细_75,size4作为文胸尺码明细_80,……
当sizebi为空的时候 size1作为衣裤尺码明细_XS,size2作为衣裤尺码明细_S,size3作为衣裤尺码明细_M,size4作为衣裤尺码明细_L,……
是不是这么写:
select *,case sizebi is not null then size1 as 文胸尺码明细_65,size2 as 文胸尺码明细_70,size3 as 文胸尺码明细_75,size4 as 文胸尺码明细_80,……,case sizebi not null then size1 as 衣裤尺码明细_XS,size2 as 衣裤尺码明细_S,size3 as 衣裤尺码明细_M,size4 as 衣裤尺码明细_L,……,f rom PQ_Out_List
[此贴子已经被作者于2019/2/28 11:56:19编辑过]