Supposing I have two tables in Oracle. One of them looks like so:

The other table I have looks like this:

This is my expected result:

How would one merge the second table with the first one for it to look like the result above? My main problem is that there are no common columns, and I have to have the values of the first table set as the column names for the second table. I'm really stuck with this one...

CodePudding user response：

You can use PIVOTing along with ROW_NUMBER() Analytic function in order to group the set by each exam per each person such as

SELECT "Mark", "Andrew", "Steve"
  FROM (SELECT Name,
               Exam || '-' || Grade AS Exam,
               ROW_NUMBER() OVER(PARTITION BY Name ORDER BY Exam DESC) AS rn
          FROM t1)
 PIVOT (
        MAX(Exam) FOR Name IN ('Mark' AS "Mark",'Andrew' AS "Andrew",'Steve' AS "Steve")
       )

where the second table is not needed

Demo

CodePudding user response：

Use the AS parameter or CROSS JOIN ?

You can also read this : How join two tables using SQL without a common column