select substr(xoq.item,2,5) model from xwp_out_quantity xoq where xoq.vendor=‘&s_vendor‘and (casewhen xoq.vendor=‘220010‘then substr(xoq.item,1) elsenullend)=9or (casewhen xoq.vendor=‘220020‘then substr(xoq.item,1) elsenullend)=8or (casewhen xoq.vendor=‘220030‘then substr(xoq.item,1) elsenullend)=7
再分享一下我老师大神的人工智能教程吧。零基础！通俗易懂！风趣幽默！还带黄段子！希望你也加入到我们人工智能的队伍中来！https://blog.csdn.net/jiangjunshow
