查询OCRD和OCQG

1楼 · 2020-09-23 23:47.采纳回答

OCRD与OCQG的合规性最终定案，由OCQ与OCQG共同完成，由AlQuénéde la de la de la de la de la de la de la de la de la de la de la de lacéode la de la de la de la de la de la de la de la de lacéo 礼炮。

 SELECT DISTINCT T0。" CardCode"，T0。" CardName"，T1。" GroupName"
 从OCRD T0左加入OCQG T1到
 （在T0时为例。" QryGroup1" ='Y'THEN 1在（T0。" QryGroup2" ='Y'时）THEN 2
 当（T0。" QryGroup3" ='Y'）则3
 当（T0。" QryGroup5" ='Y'）则5
 当（T0。" QryGroup7" ='Y'）则7
 当（T0。" QryGroup9" ='Y'）则9当（T0。" QryGroup10" ='Y'）则10
 当（T0。" QryGroup11" ='Y'）则11
 当（T0。" QryGroup13" ='Y'）则13
 当（T0。" QryGroup15" ='Y'）则15
 当（T0。" QryGroup17" ='Y'）则17当（T0。" QryGroup18" ='Y'）则18
 当（T0。" QryGroup19" ='Y'）则19当（T0。" QryGroup20" ='Y'）则20
 当（T0。" QryGroup21" ='Y'）则21
 当（T0。" QryGroup23" ='Y'）则23当（T0。" QryGroup24" ='Y'）则24
 当（T0。" QryGroup25" ='Y'）则25
 当（T0。" QryGroup27" ='Y'）则27
 当（T0。" QryGroup29" ='Y'）则29当（T0。" QryGroup30" ='Y'）则30
 当（T0。" QryGroup31" ='Y'）则31
 当（T0。" QryGroup33" ='Y'）然后33
 当（T0。" QryGroup35" ='Y'）则35
 当（T0。" QryGroup37" ='Y'）则37
 当（T0。" QryGroup39" ='Y'）则39当（T0。" QryGroup40" ='Y'）则40
 当（T0。" QryGroup41" ='Y'）则41
 当（T0。" QryGroup43" ='Y'）则43
 当（T0。" QryGroup45" ='Y'）则45
 当（T0。" QryGroup47" ='Y'）则47当（T0。" QryGroup48" ='Y'）则48
 当（T0。" QryGroup49" ='Y'）则49当（T0。" QryGroup50" ='Y'）则50
 当（T0。" QryGroup51" ='Y'）则51当（T0。" QryGroup52" ='Y'）则52
 当（T0。" QryGroup53" ='Y'）则53当（T0。" QryGroup54" ='Y'）则54
 当（T0。" QryGroup55" ='Y'）则55
 当（T0。" QryGroup57" ='Y'）则57
 当（T0。" QryGroup59" ='Y'）则59当（T0。" QryGroup60" ='Y'）则60
 当（T0。" QryGroup61" ='Y'）则61
 当（T0。" QryGroup63" ='Y'）则63
 END）= T1。" GroupCode"

 在T0。" QryGroup1" ='Y'或" QryGroup2" ='Y'或" QryGroup3" ='Y'或" QryGroup4" ='Y'
 或" QryGroup5" ='Y'或" QryGroup6" ='Y'或" QryGroup7" ='Y'或" QryGroup8" ='Y'
 或" QryGroup9" ='Y'或" QryGroup10" ='Y'或" QryGroup11" ='Y'或" QryGroup12" ='Y'
 或" QryGroup13" ='Y'或" QryGroup14" ='Y'或" QryGroup15" ='Y'或" QryGroup16" ='Y'
 或" QryGroup17" ='Y'或" QryGroup18" ='Y'或" QryGroup19" ='Y'或" QryGroup20" ='Y'
 或" QryGroup21" ='Y'或" QryGroup22" ='Y'或" QryGroup23" ='Y'或" QryGroup24" ='Y'
 或" QryGroup25" ='Y'或" QryGroup26" ='Y'或" QryGroup27" ='Y'或" QryGroup28" ='Y'
 或" QryGroup29" ='Y'或" QryGroup30" ='Y'或" QryGroup31" ='Y'或" QryGroup32" ='Y'
 或" QryGroup33" ='Y'或" QryGroup34" ='Y'或" QryGroup35" ='Y'或" QryGroup36" ='Y'
 或" QryGroup37" ='Y'或" QryGroup38" ='Y'或" QryGroup39" ='Y'或" QryGroup40" ='Y'
 或" QryGroup41" ='Y'或" QryGroup42" ='Y'或" QryGroup43" ='Y'或" QryGroup44" ='Y'
 或" QryGroup45" ='Y'或" QryGroup46" ='Y'或" QryGroup47" ='Y'或" QryGroup48" ='Y'
 或" QryGroup49" ='Y'或" QryGroup50" ='Y'或" QryGroup51" ='Y'或" QryGroup52" ='Y'
 或" QryGroup53" ='Y'或" QryGroup54" ='Y'或" QryGroup55" ='Y'或" QryGroup56" ='Y'
 或" QryGroup57" ='Y'或" QryGroup58" ='Y'或" QryGroup59" ='Y'或" QryGroup60" ='Y'
 或" QryGroup61" ='Y'或" QryGroup62" ='Y'或" QryGroup63" ='Y'或" QryGroup64" ='Y'
 
 订单由T1。" GroupName" ASC，T0。" CardCode" ASC