I am using MS SQL. I have for instance three tables:
Items, ItemProp and Properties.
Items contains the individual items:
and other fields
ITEM_ID -> this is the primary key in Items table
PROP_ID -> this is the foreign key in ItemProp table
Suppose that there are 2 items in items table:
1, First item
2, Second item
And there are 2 records for the first item in ItemProp and 3 items for second item:
Suppose the Properties contains these:
My goal is something like this:
DEMO_ID, DEMO_NAME, PROP_NAME
1, First, A B
2, Second, B D E
So I would like to see onyla that amount of record as the amount of items (2),
and see the properties collected under one column.
Thanks in advance!