Hey Tony!
Thanks for the post... I wound up arriving at a solution that's pretty close to what you had there... here's what I'm now using!
SELECT pl_id, group_concat(re_id) AS re_ids
FROM pprops
GROUP BY pl_id
HAVING find_in_set(19, re_ids)
AND find_in_set(22, re_ids)
Working like a charm...
Well, I'm stumped on this one, the solution is probably staring me in the face, but I figgured I'd pop in here to ask quick-like.
Here's the table I'm working with:
Table Name: pprops
pp_id pl_id re_id
----- ----- -----
1 45 19
2 45 22
3 34 19
4 35 29
I'm using...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.