1 reputation
2
bio website
location Ukraine, Kharkov
age 27
visits member for 1 year, 9 months
seen Dec 5 at 15:22

Mar
5
comment SELECT only values THAT are different
Hm... realy, why? May be because it is the same, not distinct? Means, that red is present in both users.
Feb
27
awarded  Student
Feb
27
awarded  Scholar
Feb
27
accepted SELECT only values THAT are different
Feb
27
comment SELECT only values THAT are different
Your example works correct, I made some modifications for fetching colors only for exact users. Thanks! SELECT u_id, color FROM colorinfo WHERE u_id in ('2', '3') GROUP BY color HAVING count(*) = 1; sqlfiddle.com/#!2/b46c4/2/0 - live example
Feb
27
comment SELECT only values THAT are different
And if I whant to fetch data only for several users, where I have to inject WHERE u_id in ('1', '2')?
Feb
27
asked SELECT only values THAT are different