sql语句进行左连接，引用右表的标题，运行的时候有的都连上了，但是制作帆软报表的时候，有的没有显示，例如图中框起来的
sql语句： SELECT AI.DATA_AD, b.name_sku_ads as 宝贝名称, ai.NAME_BRAND, ai.goods_id 商品ID, AI.name_plan_ad , sum(ai.Impression) AS `展现量`, sum(ai.click) AS `点击量`, sum(ai.COST_RMB) AS 花费 , sum(ai.sales_rmb) AS `成交金额`, sum(ai.num_payment_order) AS `成交笔数`, sum(ai.num_collection) AS `收藏宝贝量`, sum(ai.num_cart) AS `购物车量`, sum(ai.num_pre_sale) 预售成交笔数, sum(ai.pre_sales_rmb) 预售成交金额, sum(ai.num_payment_order_zhjie) as 直接成交笔数, sum(ai.num_payment_order_jianjie) as 间接成交笔数 FROM ai LEFT JOIN (SELECT name_sku_ads,tb_product_id from baobei_sem where DATA_AD >= '2022-1-1' AND DATA_AD <= '2022-1-9' and name_brand='crocs' group by tb_product_id) as b on AI.goods_id=b.tb_product_id WHERE y_mode_ads='全渠道归因' and ai.DATA_AD >= '2022-1-1' AND ai.DATA_AD <= '2022-1-3' and ai.name_brand='crocs' GROUP BY ai.goods_id order by 成交金额 desc |
1min目标场景问卷
立即参与
