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: 
It is possible to use more than one JOIN in a query. This should solve your question.
Try this...

```
SELECT T1.ID, R1.Value,
       T2.RunId, R2.Value
FROM (blah AS T1 JOIN results AS R1
         ON R1.RUNID = table.RUNID
           And T1.RUNID IN ( /... / ))
    Cross Join (blah AS T2  JOIN results AS R2 
         ON R.RUNID = T2.RUNID
           And T2.RunId In (/... /))

```