Re: SQL Question

On 22 Mar 1996, Boris Veksler wrote:

> 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
>
> Thanks
>
> Boris
>
>

SELECT table1.ID, table2.Result1, table2.Result2, table2.Result3 FROM table1, table2
WHERE table1.Data = table2.Data; Received on Fri Mar 22 1996 - 00:00:00 CET