版权声明：powered by 大狼狗郑锴/Moshow魔手 https://blog.csdn.net/moshowgame/article/details/80666267

select *
  from t_bd_generalasstacttype g
  left join T_BD_GENERALASSTACTTYPEGROUP gp
    on gp.fid = g.fgroupid
 where gp.fname_l2 like '%品牌%'