...

View Full Version : i dont get it



mull300
01-26-2007, 09:29 PM
would any one have any idea why this query would return a row that does not meet at least two of the requirements



SELECT
COUNT(*) AS cnt FROM
info AS a
INNER JOIN exp AS b
ON a.user_id=b.userId
WHERE
a.address_type='BT'
AND a.delete_me='N'
AND
(b.industry=29 AND b.industry_private='N')
AND
(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.

Fumigator
01-27-2007, 12:29 AM
You're selecting a count(*) so how do you know what IDs it's selecting?



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum