left join table_a on ...like...

重写这段代码 CREATE OR REPLACE PROCEDURE ord_dev AS bill_date VARCHAR2(10); v_sql LONG; v_count NUMBER; v_time VARCHAR2(20); v_d VARCHAR2(2); v_m VARCHAR2(2); CURSOR c_tb IS SELECT * FROM b_cur_names; c_row b_cur_names%ROWTYPE; BEGIN EXECUTE IMMEDIATE 'truncate table b_cur_names'; v_sql := 'insert into b_cur_names Select TABLE_NAME from SYS.ALL_TABLES a Where a.owner =upper(''jour1'') And a.table_name Like upper(''om_subscriber_202___'') and Substr(a.table_name,-6) > 202205 order by 1'; COMMIT; EXECUTE IMMEDIATE 'DROP table ord_dev'; ---------------- v_sql := 'insert into ord_dev Select a.order_id,a.done_date, a.cust_id, a.subscriber_ins_id, a.access_num, c.dev_id, c.dev_name, c.corp_org, c.company_name, c.department_code, c.department_name, c.remarks From JOUR1.Om_Subscriber_202301 a Left Join JOUR1.om_order_202301 b On a.order_id = b.order_id Left Join params1.sec_developer c On b.dev_id = c.dev_id Where 1 =2 '; COMMIT; ------------- FOR c_row IN c_tb LOOP v_sql := ' insert into ord_dev Select a.order_id,a.done_date, a.cust_id, a.subscriber_ins_id, a.access_num, c.dev_id, c.dev_name, c.corp_org, c.company_name, c.department_code, c.department_name, c.remarks From JOUR1.Om_Subscriber_' || substr(c_row.table_name, -6) || ' a Left Join JOUR1.om_order_' || substr(c_row.table_name, -6) || ' b On a.order_id = b.order_id Left Join params1.sec_developer c On b.dev_id = c.dev_id Where 1 = 1 And a.access_num Like ''192%'' And a.action = 0'; COMMIT; END LOOP; END;

func PostFeedBackList(a *decorator.ApiBase, data *adminStruct.FeedBackList) error { logger.AccessLogger.Info("PostFeedBackList...") res := adminStruct.AfterSaleResp{} f := []adminStruct.AFeedBackList{} query := a.Ts.Table("feedback a"). Select("a.fid,a.gid,m.star,u.user_name,a.appraise_time,boi.order_no,m.shop_id"). Joins("left join reply_temp m on a.mid=m.mid"). Joins("left join business_order_info boi on boi.uid=a.uid"). Joins("left join user_base u on u.uid=a.uid ") if len(data.ShopId) > 0 { query = query.Where("m.shop_id like ?", data.ShopId) } if data.Gid > 0 { query = query.Where("a.gid like ?", data.Gid) } if len(data.OrderNo) > 0 { query = query.Where("boi.order_no like ?", data.OrderNo) } if len(data.UserName) > 0 { query = query.Where("u.user_name like ?", data.UserName) } if data.Star > 0 { query = query.Where("m.star like ?", data.Star) } if data.AppraiseTime > 0 { query = query.Where("a.appraise_time like ? ", data.AppraiseTime) } utils.Error(query.Find(&res.Data).Error) var fids []int64 for _, i := range res.Data { fids = append(fids, i.Fid) } utils.Error(a.Ts.Table("feedback a"). Select("g.image,g.gname,boi.order_no,u.user_name,m.star,a.appraise_time,a.appraise_text,m.country,m.shop_id"). Joins("left join goods_base g on a.gid=g.gid"). Joins("left join reply_temp m on a.mid=m.mid"). Joins("left join business_order_info boi on boi.uid=a.uid"). Joins("left join user_base u on u.uid=a.uid "). Where("a.fid like ?", fids). Find(&f). Error) return a.ReturnSuccessCustomResponse(res) }

SELECT a.*, r.id AS rid, r.`name` AS rname, r.nameZh AS rnameZh FROM t_admin a LEFT JOIN t_admin_role ar ON a.id = ar.adminId LEFT JOIN t_role r ON r.id = ar.rid WHERE a.id != 1 AND a.`name` LIKE ( "%", "华", "%" ) ORDER BY a.id

from FEE_LIST_D a LEFT JOIN SETL_D b on a.SETL_ID = b.SETL_ID AND a.FIXMEDINS_CODE = b.FIXMEDINS_CODE LEFT JOIN MDTRT_D c on a.MDTRT_ID = c.MDTRT_ID AND a.FIXMEDINS_CODE = c.FIXMEDINS_CODE 字符集不匹配