Hi, it probably a trivial question, but...
Given:
Each Experiment (ID) has data (Data) - table 1,
each data (Data) may produce several different results (Result) - Table 2.
Create
-> Therefor each experiment may produce several different results - Table 3
I need to write SQL query to do it. Any idea?
Input table 1:
ID | Data
1 | d1
2 | d2
3 | d3
Input table 2:
Data | Result1 | Result2 | Result3
d1 | r1 | r2 | r3
d2 | r2 | r3 |
d3 | r3 | r4 | r5
I need to write a SQL query that will create table like this:
Output table 3:
ID | Result1 | Result2 | Result3
1 | r1 | r2 | r3
2 | r2 | r3 |
3 | r3 | r4 | r5