I'm trying a simple self join, but it's output is some what erratic. 

My table (input) looks like this:

```
 ID  |   Value    
 1   |    val1   
 1   |    val2   
 1   |    val3  
 2   |    val4   
 2   |    val5   
 2   |    val6  
 2   |    val7

```

What I am trying to achieve is the following: 

```
 ID 1  |   Value 1  | ID 2  |   Value 2  
 1     |    val1    | 2     |   val4   
 1     |    val2    | 2     |   val5  
 1     |    val3    | 2     |   val6  
 Null  |    Null    | 2     |   val7  

```

My attempt at achieving this output has been the following: 

```
SELECT DISTINCT 
    column1.ID,
    column1.value,
    column2.ID,
    column2.value
FROM table column1   
INNER JOIN table column2 ON column1.ID = 1 AND column2.ID = 2    

```

This chunk of code returns the incorrect number of rows; the total number of rows I should get is 4 with a few a null values in the last. I don't get any null values but I do get some numbers which I don't know how are getting there. Additionally, if choose to display more fields from my table, the numbers of rows returned grows larger. I don't understand this behavior. Can Somebody please help me fix it? (and possibly tell me what I am doing wrong).