| List: | General Discussion | « Previous MessageNext Message » | |
| From: | (Hal | Date: | March 3 2012 4:49am |
| Subject: | Re: Multi select Query help... | ||
| View as plain text | |||
>>>> 2012/03/01 19:56 -0800, Don Wieland >>>>
I do not get the same results. Am I missing something? Hopefully
something simple ;-)
<<<<<<<<
O, you are. You do not want GROUP_CONCAT in the subquery. It gives you the comma-separated
string whereto you referred, which, as far as the IN goes, is only one string for
comparing for equality. You want the IDs separate, not joined into one string.
| Thread | ||
|---|---|---|
| • Multi select Query help... | Don Wieland | 2 Mar |
| • Re: Multi select Query help... | hsv | 3 Mar |