Please have a look at SQLFiddle below   

<http://sqlfiddle.com/#!2/5dd713/2/0>

I have two tables. And I union both tables to get the data that I am looking for 
But I would like to remove the duplicates and use info from table1 as the priority 

currently the table looks like this (info1 comes from table1 and info2 comes from table2)

```
1, info1
2, info1
3, info1
3, info2
4, info1
4, info2
5, info1
5, info2
6, info2
7, info2

```

So the end result will look like below

```
1, info1
2, info1
3, info1
4, info1
5, info1
6, info2
7, info2

```

how can I do this?

thank you