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

    Concat()

    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 ?

       

      Thanks