当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