Question: ok so this is what I am trying to achieve is to have two SELECT statements and then join results of each so I have something like this

```
SELECT table.ID, tst.Value 
FROM blah AS table JOIN results AS tst ON tst.RUNID = table.RUNID
WHERE table.RUNID IN
(
  ...// nothing important but in the end i get my tst.Value  
)

```

second statement is almost identical

```
SELECT table.ID, tst2.Value 
FROM blah AS table JOIN results AS tst2 ON tst2.RUNID = table.RUNID
WHERE table.RUNID IN
(
  ...// nothing important but in the end i get my tst2.Value differently
)

```

I need to combine these two results in format of

```
SELECT table.ID, tst.Value, tst2.Value
...... // Somehow using those two statements

```

So anyone fluent in SQL language who could tell me how to do this or what statements should I use...Join sound like a good place to start but they use tables. I guess I could use a CREATE TABLE from SELECT and join but as I said I am not fluent in SQL so wondering if thats good idea or there is a better idea...

Thanks :)

Answer: 
The naive approach, assuming `table.ID` is what relates the two `value` fields:

```
SELECT first_subquery.ID, first_subquery.Value, second_subquery.Value
FROM (
  SELECT table.ID, tst.Value 
  FROM blah AS table JOIN results AS tst ON tst.RUNID = table.RUNID
  WHERE table.RUNID IN
  (
    ...// nothing important but in the end i get my tst.Value  
  )
) first_subquery
INNER JOIN (
  SELECT table.ID, tst2.Value 
  FROM blah AS table JOIN results AS tst2 ON tst2.RUNID = table.RUNID
  WHERE table.RUNID IN
  (
    ...// nothing important but in the end i get my tst2.Value differently
  )
) second_subquery
ON first_subquery.ID = second_subquery.ID

```

This query is based on both of yours, joined together.
This should work for you:

```
SELECT table.ID, tst.Value, tst2.Value 
FROM blah AS table 
Inner JOIN results AS tst ON tst.RUNID = table.RUNID
Inner JOIN results AS tst2 ON tst2.RUNID = table.RUNID
WHERE table.RUNID IN
(  
  ...// nothing important but in the end i get my tst2.Value differently
)

```