title: How to Refer Foreign Key table to refer another table?
body: <p>I have Two Table Two Table Name called Following on this</p>
  
  <pre><code>1. TP_Users
  2. TP_Roles
  </code></pre>
  
  <p><code>TP_Users</code> Have Following Fields  </p>
  
  <pre><code>Id (PK, int, not null)
  UserName (nvarchar(50), null)
  UserEmail (nvarchar(50), null)
  DisplayName (nvarchar(50), null)
  Password (nvarchar(50), null)
  RoleId (FK, int, not null)
  IsActive (bit, not null) ------&gt;Foreign Key Reference 
  ClientId (int, null)
  </code></pre>
  
  <p><code>TP_Roles</code> have Following Fields </p>
  
  <pre><code>Id  PK, int, not null
  Role_Name   varchar(200), null
  IsActive    bit, null
  </code></pre>
  
  <p><code>TP_Users</code>  Parent table  column name <code>RoleId</code> its  Refrenced table  <code>TP_Roles</code>       column name <code>id</code>.<br>
  How to make  relationships and how the link two tables using query ?  </p>