mysql 5 个表select distinct Product.id, Product.name from products as Product left join products_categories on (Product.id=products_categories.product_id) left join categories AS Category on (products_categories.category_id = categories.id) where Product.name LIKE '%da4b9237bacccdf19c0760cab7aec"a8359010b0%' or Maker.name LIKE '%da4b9237bacccdf19c0760cab7aec"a8359010b0%' or Category.name LIKE '%da4b9237bacccdf19c0760cab7aec"a8359010b0%' order by Product.id asc limit 10 offset 0
1054: Unknown column 'Maker.name' in 'where clause'各位大侠,小弟初来乍到..还望多指点一二.
还有 就是.....救命啊!!!!!!!!!!!!!!!!!!!!!!!!哪在哪里??在线等
1054: Unknown column 'Maker.name' in 'where clause'各位大侠,小弟初来乍到..还望多指点一二.
还有 就是.....救命啊!!!!!!!!!!!!!!!!!!!!!!!!哪在哪里??在线等
select distinct Product.id, Product.name from products as Product left join products_categories on (Product.id=products_categories.product_id) left join categories AS Category on (products_categories.category_id = categories.id)
left join makers AS Maker on (products_makers.maker_id = Maker.id)
where Product.name LIKE '%da4b9237bacccdf19c0760cab7aec"a8359010b0%' or Maker.name LIKE '%da4b9237bacccdf19c0760cab7aec"a8359010b0%' or Category.name LIKE '%da4b9237bacccdf19c0760cab7aec"a8359010b0%' order by Product.id asc limit 10 offset 0
select distinct Product.id, Product.name from products as Product left join products_categories on (Product.id=products_categories.product_id) left join categories AS Category on (products_categories.category_id = categories.id)
left join makers AS Maker on (products_makers.maker_id = Maker.id)
where Product.name LIKE '%da4b9237bacccdf19c0760cab7aec"a8359010b0%' or Maker.name LIKE '%da4b9237bacccdf19c0760cab7aec"a8359010b0%' or Category.name LIKE '%da4b9237bacccdf19c0760cab7aec"a8359010b0%' order by Product.id asc limit 10 offset 0