title: joining columns of same table with different criteria - SQL
body: <p>I am able to query with one condition ( as shown in image below ) but when i query with couple of criterias and trying to create two same columns of same table with different criteria, i get no result. 2nd Image is the expected result which i am not able to retrieve. Any inputs are highly appreciated. Thanks. </p>
  
  <pre><code>select save_line from save_output_table  
  where execution_id in ('292') 
    and seq_id = '0' 
    and save_type='R' 
  order by line_id ASC
  
  +------------+
  | Save_line  |
  +------------+
  |         17 |
  |         22 |
  |         23 |
  +------------+
  
  
  
  SELECT 
  ( select save_line 
    from save_output_table
    where execution_id in ('292') 
      and seq_id = '0' 
      and save_type='R' 
      order by line_id ASC 
  ) as save_line1,
  ( select save_line 
    from save_output_table  
    where execution_id in ('286') 
      and seq_id = '0' 
      and save_type='R' 
      order by line_id ASC 
  ) as save_line2
  from save_output_table 
  
   +-------------+------------+
   | Save_line 1 | Save_line2 |
   +-------------+------------+
   |          17 |          9 |
   |          22 |          5 |
   |          23 |          3 |
   +-------------+------------+
  </code></pre>
  
  <p>Sample Data : </p>
  
  <pre><code> +---------------+--------+-----------+---------+-----------+
   | execution_id  | seq_id | save_type | line_id | save_line |
   +---------------+--------+-----------+---------+-----------+
   |           286 |      0 | R         |       1 |        17 |
   |           286 |      0 | R         |       2 |        22 |
   |           286 |      0 | R         |       3 |        23 |
   |           286 |      0 | D         |       1 |        17 |
   |           286 |      0 | D         |       2 |        22 |
   |           286 |      0 | D         |       3 |        23 |
   |           292 |      0 | R         |       1 |         9 |
   |           292 |      0 | R         |       2 |         5 |
   |           292 |      0 | R         |       3 |         3 |
   |           292 |      0 | D         |       1 |        98 |
   |           292 |      0 | D         |       2 |       622 |
   |           292 |      0 | D         |       3 |       273 |
   +---------------+--------+-----------+---------+-----------+
  </code></pre>