主题：sql语句请教

 当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