<html><head></head><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:14px"><div dir="ltr" id="yui_3_16_0_ym19_1_1472698475600_7558">Pl refer to this link, it has my exact problem (but it only tells about SQL solution): <a id="yui_3_16_0_ym19_1_1472698475600_7772" class="" href="http://stackoverflow.com/questions/11409869/mysql-nm-relationship-find-rows-with-several-specific-relations">http://stackoverflow.com/questions/11409869/mysql-nm-relationship-find-rows-with-several-specific-relations</a></div><div id="yui_3_16_0_ym19_1_1472698475600_7779"><br></div><div id="yui_3_16_0_ym19_1_1472698475600_7515">I have three tables:</div><div id="yui_3_16_0_ym19_1_1472698475600_7521" dir="ltr">1. products:-> prod-id, prod-name<br></div><div id="yui_3_16_0_ym19_1_1472698475600_7520" dir="ltr">2. tags:-> tag-id, tag-name<br></div><div id="yui_3_16_0_ym19_1_1472698475600_7516" dir="ltr">3. product_tags::-> prod-id, csv_tag_id</div><div id="yui_3_16_0_ym19_1_1472698475600_7517" dir="ltr"><br></div><div id="yui_3_16_0_ym19_1_1472698475600_7518" dir="ltr">i read elsewhere on internet that this is not a good database/table design. so i am ready to change that too, but i could not think of any other way to represent this relationship. a given product could have multiple tags, but i have to find - at a given time - only those products which have 'ALL' of multiple given tags.</div><div id="yui_3_16_0_ym19_1_1472698475600_7717" dir="ltr"><br></div><div id="yui_3_16_0_ym19_1_1472698475600_7716" dir="ltr">the SQL suggested on the page is:</div><div id="yui_3_16_0_ym19_1_1472698475600_7715" dir="ltr"><br></div><pre id="yui_3_16_0_ym19_1_1472698475600_7666" style=""><code id="yui_3_16_0_ym19_1_1472698475600_7667"><span id="yui_3_16_0_ym19_1_1472698475600_7668">SELECT</span><span id="yui_3_16_0_ym19_1_1472698475600_7669"> a</span><span id="yui_3_16_0_ym19_1_1472698475600_7670">.*</span><span id="yui_3_16_0_ym19_1_1472698475600_7671">
</span><span id="yui_3_16_0_ym19_1_1472698475600_7672">FROM</span><span id="yui_3_16_0_ym19_1_1472698475600_7673"> products a
</span><span id="yui_3_16_0_ym19_1_1472698475600_7674">INNER</span><span id="yui_3_16_0_ym19_1_1472698475600_7675"> </span><span id="yui_3_16_0_ym19_1_1472698475600_7676">JOIN</span><span id="yui_3_16_0_ym19_1_1472698475600_7677"> product_tags b </span><span id="yui_3_16_0_ym19_1_1472698475600_7678">ON</span><span id="yui_3_16_0_ym19_1_1472698475600_7679"> a</span><span id="yui_3_16_0_ym19_1_1472698475600_7680">.</span><span id="yui_3_16_0_ym19_1_1472698475600_7681">product_id </span><span id="yui_3_16_0_ym19_1_1472698475600_7682">=</span><span id="yui_3_16_0_ym19_1_1472698475600_7683"> b</span><span id="yui_3_16_0_ym19_1_1472698475600_7684">.</span><span id="yui_3_16_0_ym19_1_1472698475600_7685">product_id
</span><span id="yui_3_16_0_ym19_1_1472698475600_7686">WHERE</span><span id="yui_3_16_0_ym19_1_1472698475600_7687"> b</span><span id="yui_3_16_0_ym19_1_1472698475600_7688">.</span><span id="yui_3_16_0_ym19_1_1472698475600_7689">tag_id </span><span id="yui_3_16_0_ym19_1_1472698475600_7690">IN</span><span id="yui_3_16_0_ym19_1_1472698475600_7691"> </span><span id="yui_3_16_0_ym19_1_1472698475600_7692">(</span><span id="yui_3_16_0_ym19_1_1472698475600_7693">1</span><span id="yui_3_16_0_ym19_1_1472698475600_7694">,</span><span id="yui_3_16_0_ym19_1_1472698475600_7695">23</span><span id="yui_3_16_0_ym19_1_1472698475600_7696">,</span><span id="yui_3_16_0_ym19_1_1472698475600_7697">54</span><span id="yui_3_16_0_ym19_1_1472698475600_7698">)</span><span id="yui_3_16_0_ym19_1_1472698475600_7699">
</span><span id="yui_3_16_0_ym19_1_1472698475600_7700">GROUP</span><span id="yui_3_16_0_ym19_1_1472698475600_7701"> </span><span id="yui_3_16_0_ym19_1_1472698475600_7702">BY</span><span id="yui_3_16_0_ym19_1_1472698475600_7703"> a</span><span id="yui_3_16_0_ym19_1_1472698475600_7704">.</span><span id="yui_3_16_0_ym19_1_1472698475600_7705">product_id
</span><span id="yui_3_16_0_ym19_1_1472698475600_7706">HAVING</span><span id="yui_3_16_0_ym19_1_1472698475600_7707"> COUNT</span><span id="yui_3_16_0_ym19_1_1472698475600_7708">(</span><span id="yui_3_16_0_ym19_1_1472698475600_7709">1</span><span id="yui_3_16_0_ym19_1_1472698475600_7710">)</span><span id="yui_3_16_0_ym19_1_1472698475600_7711"> </span><span id="yui_3_16_0_ym19_1_1472698475600_7712">=</span><span id="yui_3_16_0_ym19_1_1472698475600_7713"> </span><span id="yui_3_16_0_ym19_1_1472698475600_7714">3</span></code></pre><div id="yui_3_16_0_ym19_1_1472698475600_7309">thank you.</div><div id="yui_3_16_0_ym19_1_1472698475600_7928">Rajeev<br></div></div></body></html>