Databases :: Retrieve Data From Two Tables?

I've a problem in MySql.I need to retrieve data from two tables,in which one field is common in both the tables and I need to retrieve distinct data.But all I'm getting is this :

Id Name Initial
1 abc A
1 abc A
1 abc A
2 def B
2 def B
2 def B

How can I make it like this :

Id Name Initial
1 abc A
2 def B
3 ghi C