network profile
| bio | website | |
|---|---|---|
| location | Ukraine, Kharkov | |
| age | 26 | |
| visits | member for | 3 months |
| seen | Apr 1 at 10:13 | |
| stats | profile views | 2 |
|
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 |
