#-------------产品表匹配添加多层级关系最终版------------------
SELECT * FROM PRODUCT P --主表
LEFT JOIN PRODUCT_LEVEL L ON L.ID=SUBSTR(P.LV_5_ID,0,3) --一对多:唯一值在前
LEFT JOIN PRODUCT_LEVEL L ON L.ID=SUBSTR(P.LV_5_ID,0,6)
LEFT JOIN PRODUCT_LEVEL L ON L.ID=SUBSTR(P.LV_5_ID,0,9)
LEFT JOIN PRODUCT_LEVEL L ON L.ID=SUBSTR(P.LV_5_ID,0,12)
业务场景5(串产品层级表和业绩表获取中间层级汇总数据)left join
最新推荐文章于 2024-07-16 10:16:48 发布