SQL Server 2012 :: Returning Value For Foreign Key

I have a table tbl_rules. This table will define rules for each role. I have not yet defined the fields for the rules. But the table definition is as below:

Create table tbl_Rules
(
ID int identity(1,1) not null,
Role_ID int not null,
primary key (ID),
constraint fk_RoleName foreign key (Role_ID)
references tbl_Role(ID)
)

The table tbl_role has two columns as below:

ID RoleName
1 Manager
2 Analyst
3 Admin

So far so good. I created the tbl_rules.

But what i want to do is when I do select * from tbl_Rules, i want to show as below:

ID Role_ID
1 Manager
2 Admin

Instead it shows:

ID Role_ID
1 1
2 3

Is there a way to do this? The goal is to return the select * from tbl_Rules results to a gridview to enable adds and changes. I could do this by doing queries for each column, but I was hoping to make it easier. Not sure if this is even possible.