would any one have any idea why this query would return a row that does not meet at least two of the requirements
COUNT(*) AS cnt FROM
info AS a
INNER JOIN exp AS b
(b.industry=29 AND b.industry_private='N')
(b.title LIKE 'web%' AND b.title_private='N')
the two that are red are the ones that dont match at all. in fact the user its pulling doesnt even have a row in the exp table.