SQL GROUPING QUERY - H2 DataBase

I have a table with items, their properties, and those properties' values. I would like to construct a query that produces unique rows for each property having all the different values from 开发者_开发百科the different items in a single row.

From ITEM PROPERTY VALUE

To PROPERTY item1Value item2Value item3Value ....

Has anyone solved this situation before?

Thanks in advance, regards!

sounds like you need to do PIVOT table. below is the link that explains it in very good details.

http://msdn.microsoft.com/en-us/library/ms177410.aspx

if you give your table definition with datatype i can help with query