title: Is it possible to Show Text instead of ID using SELECT * from TableName
body: <p>I have two tables as given below:</p>
  
  <h3>person_detail</h3>
  
  <pre><code>id     name    role_id
  ---------------------------
  1      Hamdan    1
  2      Sara      2
  3      John      2
  </code></pre>
  
  <h3>tbl_user_roles</h3>
  
  <pre><code>id     role
  ---------------
  1      Admin
  2      Author
  </code></pre>
  
  <h3>Result I need:</h3>
  
  <pre><code>id     name    user_role
  ---------------------------
  1      Hamdan    Admin
  2      Sara      Author
  3      John      Author
  </code></pre>
  
  <blockquote>
    <p>Note: <strong>is it possible?</strong> to use on [Select * from tblPerson] statement, because I do not want to type each field name like:
    I have these Two(2) solutions, but I want to use SELECT statement only.</p>
  </blockquote>
  
  <h3>Solution 1</h3>
  
  <pre><code>SELECT p.id, p.person_name, roles.role
  FROM person_detail p
  INNER join user_roles roles
  ON p.role_id = roles.id
  </code></pre>
  
  <h3>Solution 2</h3>
  
  <pre><code>SELECT p.id,
  p.person_name,
  (SELECT user_roles.role FROM dbo.user_roles WHERE id = p.role_id) As 'user_role' 
  FROM dbo.person_detail p
  </code></pre>
  
  <h3>::Both works fine, but I don't want ti use above two solutions</h3>