How to fetch all the variants, of each products, with out fetching product name multiple time <p>I have 3 tables.</p> <p>"table_products" </p> <pre><code> product_id product_name 1 A 2 B 3 C 4 D 5 E </code></pre> <p>"table_varients"</p> <pre><code>variant_id variant_name 1 v1 2 v2 3 v3 4 v4 5 v5 </code></pre> <p>"table_product_varients"</p> <pre><code>product_id variant_id 1 1 1 2 1 3 2 3 2 4 3 1 3 4 4 1 5 1 5 2 </code></pre> <p>And i want result from select Query like this:</p> <pre><code>A - V1, V2, V3 B - V3, V4 C - V1, V4 D - V1 E - V1, V2 </code></pre> <p>Devesh</p>