SELECT

adv,
advlogo,
advurl,
cat,
caturl,
instr,
blockanch,
anch,
gotourl,
code,
DATE_FORMAT(expdate, '%d %M, %Y') AS formated_date,
expun

FROM tadv, tcat, tinstr, tcoupon

LEFT JOIN texpun on tcoupon.expunid=texpun.expunid

WHERE

tcoupon.advid=tadv.advid AND
tcoupon.catid=tcat.catid AND
tcoupon.instrid=tinstr.instrid;

I want to add the following but it doesn't work:

AND type='a' ¦¦ type='c';

Funny thing is, it works without all the other WHERE clauses. For example:

SELECT * from tcoupon WHERE type='a' ¦¦ type='c';

Anyone know how to add it on successfully?

[edited by: Tehuti at 10:07 pm (utc) on Sep. 14, 2008]