9 Replies Latest reply: Jun 30, 2015 3:11 AM by Richard Chilvers RSS


    Richard Chilvers

      I have a table of products and each product has one or more features.


      Product  Feature

      Car 1      Red

      Car 1      4dr

      Car 1       Leather seats

      Car 2       5dr

      Car 2        Red



      etc.....you get the idea.


      I have a table which shows each product, with all its features in a single column using the CONCAT function:


      eg.    Car 1       Red; 4dr; Leatherseats


      This works well. Except, if I SELECT a Feature (eg. Red), I (correctly) see all products which are Red, but I don't see their other features.



      Is there a way I can show all Features for all Products which have the SELECTed Feature ?