How to join 2 tables without duplicates (SQL server)?

[prowler]

I have two following tables:

table1:

id name city subject

1 name1 city1 subject1
2 name2 city2 subject2
3 name3 city3 subject3
4 name4 city4 subject4
...

table2:

id name city subject

1 name1 city1 subject1
2 name2 city2 subject2
3 name3 city3 subject3
4 name4 city4 subject4
...

How to avoid duplication's when joining these 2 tables?

[jules]

You can use distinct function

[irl]

UNION checks for duplicates and only distinct rows will be returned

SELECT * FROM table1
UNION SELECT * FROM table2