Let's I have a inner join which results in a table as follows

```
WORKFLOWID  Value
1           One
1           Two
2           Three
2           Four

```

But what I want for this is one record to come back

```
ID    Value1 Value2
1     One    Two
2     Three  Four

```

What options do I have in SQL to change an inner join to behave as above ?

```
SELECT ws.workflow_id as WorkflowId, sg.unmatched_value as UnmatchedValue
FROM [geo_workflow_step] as ws 
INNER JOIN [geo_workflow] as gw on ws.workflow_id = gw.id
INNER JOIN [geo_super_group] as sg on gw.super_group_id = sg.ID
order by WorkflowId

```