SELECT *
FROM download AS c
INNER JOIN products AS p
WHERE hpmc LIKE '%chip%'
AND (
c.name != '0'
OR c.name1 != '0'
OR c.name1 != '0'
)
FROM download AS c
INNER JOIN products AS p
WHERE hpmc LIKE '%chip%'
AND (
c.name != '0'
OR c.name1 != '0'
OR c.name1 != '0'
)
然后结果:
A B
A1 B1
A1 B2
A1 ...
A1 Bn
A2 B1
A2 B2
A2 ...
A2 Bn
... ...
INNER JOIN就不会了