SQL - merge two database tables into one databse table

I need to create a view (or a table) that holds n row values, taken from two different tables that have the same structure. For example:

table Country

id    name        Country
----------------------------
1     Franz       Germany
2     Alberto     Italy
3     Miguel      Spain

table email

id    name        Email
----------------------------
1     Franz       franz@gmail.com
2     Alberto     alberto@gmail.com
3     Miguel      miguel@gmail.com

table phoneno

id    name        Phone
----------------------------
1     Franz       111-111-1111
2     Alberto     111-111-1111
3     Miguel      111-111-1111

The merged databse has to be like this:

id    name        Country        Email                 Phone
---------------------------------------------------------------------
1     Franz       Germany        franz@gmail.com       111-111-1111
2     Alberto     Italy          alberto@gmail.com     111-111-1111
3     Miguel      Spain          miguel@gmail.com      111-111-1111

it's possible? if it is, how?

Thanks in advance for your help, best regards