1

I have 3 tables.

+---------+
|  items  |
+---------+
| item_id |
| ...     |
+---------+

+----------------------+
|   item_text_values   |
+----------------------+
| item_text_value_id   |
| item_id              |
| custom_field_name_id |
| value                |
+----------------------+

+----------------------+
|  custom_field_names  |
+----------------------+
| custom_field_name_id |
| index                |
| name                 |
+----------------------+

the count of item_text_values is unknown. It can be three 3 or 10 or more. I would like to have a view or stored procedure that returns me row with variable columns depending on how many item_text_values records are there.

I have classic join

SELECT *
 FROM items
LEFT JOIN item_text_values ON item_text_values.item_id = items.item_id
LEFT JOIN custom_field_names ON custom_field_names.custom_field_name_id = item_text_values.custom_field_name_id
WHERE items.item_id = 1

which returns me 2 rows if there are 2 records of item_text_values. And I want to merge these two rows into one with variable columns depending on how many item_text_values are there. Don't know if this is even possible.

Thank you

ferdinand
  • 970
  • 1
  • 7
  • 14

0 Answers0