Re: Cross Reference Help

[Kerry Wilson]

The HAVING keyword did not seem to work and I could not find any documentation on the site. Is it available for 4.0.24? I did try a subquery though and it didn't work either. Here it is:

SELECT dealers.dealerName, dealers.dealerId
FROM dealers
LEFT JOIN ( SELECT count( * ) AS count, dealerId
FROM dealerMappings
WHERE categoryId
IN ( 5, 8 )
GROUP BY dealerId
) AS tally
ON dealers.dealerId = tally.dealerId
WHERE tally.count =2
GROUP BY dealers.dealerId
ORDER BY dealers.dealerName

Is there anything wrong with this statement