title: How to select all records from a table by replacing values for two fields from other tables?
body: <p><a href="https://i.stack.imgur.com/Bqj93.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Bqj93.jpg" alt="DB Design"></a></p>
  
  <p>This is the table design of an application I need to build. Kindly ignore the Role Table in the image.</p>
  
  <p>Is there any method by which I can select all the records in the table transfer log , but instead of showing "User No" and "Plant No" in the result , I need to show the corresponding Employee No/Username from the user table and corresponding Plant Id from Plant Table.</p>