Skip to content
Advertisement

Adding new data in columns, from another table – SQL ORACLE

I have a table with some records

MASTER TABLE

I have another table with parameters of this record (ID)

TABLE2

As result I want this: (combine based on ID)

Result table

How Can I do something like that? Inner join will not work I think.

Advertisement

Answer

Join the tables and use conditional aggregation with case to extract the 2 columns:

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement