sql语句查询like问题

SELECT * FROM (SELECT * FROM kg_goodsmanagedetail WHERE StoreHoseNo >0 AND SarkManageID=12) AS a LEFT JOIN (SELECT * FROM (SELECT distinct (kg_goodsmanagedetail.ID) AS MAID FROM kg_goodsmanagedetailpower left join kg_goodsmanagedetail on kg_goodsmanagedetail.ID=kg_goodsmanagedetailpower.goodsmanagedetailid ) AS a LEFT JOIN kg_goodsmanagedetailpower ON kg_goodsmanagedetailpower.ID=a.MAID) AS b ON b.MAID=a.ID LEFT JOIN sys_centerbank ON sys_centerbank.ID=a.CenterBankID LEFT JOIN sys_bank ON sys_bank.ID=a.BankID LEFT JOIN sys_users ON sys_users.ID=a.UserID LEFT JOIN kg_goodsmanage ON kg_goodsmanage.ID=a.GoodsManageID LEFT JOIN kg_sarkmanage ON kg_sarkmanage.ID=a.SarkManageID and kg_goodsmanage.GoodsName like '%四号%'

这个语句我后面加上and kg_goodsmanage.GoodsName like '%四号%' 为什么不生效

SELECT
    * 
FROM
    ( SELECT * FROM kg_goodsmanagedetail WHERE StoreHoseNo > 0 AND SarkManageID = 12 ) AS a
    LEFT JOIN (
SELECT
    * 
FROM
    ( SELECT DISTINCT ( kg_goodsmanagedetail.ID ) AS MAID FROM kg_goodsmanagedetailpower LEFT JOIN kg_goodsmanagedetail ON kg_goodsmanagedetail.ID = kg_goodsmanagedetailpower.goodsmanagedetailid ) AS a
    LEFT JOIN kg_goodsmanagedetailpower ON kg_goodsmanagedetailpower.ID = a.MAID 
    ) AS b ON b.MAID = a.ID
    LEFT JOIN sys_centerbank ON sys_centerbank.ID = a.CenterBankID
    LEFT JOIN sys_bank ON sys_bank.ID = a.BankID
    LEFT JOIN sys_users ON sys_users.ID = a.UserID
    LEFT JOIN kg_goodsmanage ON kg_goodsmanage.ID = a.GoodsManageID
    LEFT JOIN kg_sarkmanage ON kg_sarkmanage.ID = a.SarkManageID 
    where kg_goodsmanage.GoodsName LIKE '%四号%'   -- and 换成 where 试试

• 请看👉 ：SQL中模糊查询 like使用
• 你还可以看下mysql参考手册中的 MySQL SQL语句
• 另外, 我还从CSDN技能树中找了一些相关资料给你, 你可以学习下:
• 相关参考资料: SQL查询