Here is the scenario:
-- I have table1 that has one primary key (PK1)
-- Another table called table2 with two primary keys (PK1, LINE#). This table has another column called COL1 that will have values VAL1, VAL2, VAL3 etc. corresponding to LINE# values of 1, 2, 3 and so on
I would like to write a SQL query that will return the following output in one row
Can you help me how I can achieve this?