Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- Need help with a complex MySQL select statement


plogger - 8:52 pm on Dec 5, 2011 (gmt 0)


I got this from someone on another forum, and it works perfectly:

select user
from ratings
where item in (344,476)
group
by user
having count(distinct item) = 2


Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4394475.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com