27,580
社区成员
发帖
与我相关
我的任务
分享
SELECT *
FROM Goods
JOIN Store ON Goods.Storeid = Store.ID
JOIN goodsClassify ON goodsClassify.id = Goods.classifyId
WHERE Goods.title LIKE '%' + param.getKey() + '%'
OR Store.name LIKE '%' + param.getKey() + '%'
OR goodsClassify.name LIKE '%' + param.getKey() + '%'