Hello, I have a table LINE(ID, NAME) AND a table TAG(ID, LINEID, TAG, VAL).
Here is a example of content : - Table LINE ID|NAME | 1 |TEST1| 2 |TEST2| - Table TAG ID|LINEID|TAG|VAL| 1 |1 |A |ABC| 2 |1 |B |456| 3 |1 |E |789| 4 |2 |A |123| 5 |2 |B |147| 6 |2 |C |258| 7 |2 |D |369| I want to make a request which return tags as column like below : NAME |A |B |C |D |E | TEST1|ABC|456| | |789| TEST2|123|147|258|369| | Is it possible to use Pivot with H2? Thanks, Phil -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
