如: 数据表:A1 字段:B1,B2,B3 数据:Y1,Y2,Y3 很多条记录 数据表:A2 字段:B1,B2 数据:Y1,Y2
SELECT A1.B1, A1.B2, A1.B3 FROM A1 INNER JOIN A2 ON A1.B1 = A2.B1 AND A1.B2 = A2.B2 and A2.B3 = 1三表不查询重复记录select goods.id,goods.description,goods.attributes, categories.`name`,categories.ename from (goods inner join categories on goods.category_id = categories.category_id) INNER JOIN attribute on goods.attributes = attribute.name where categories.`level` = 1