title: How to get names of relevant ID's from 2 different tables and display them
body: <p>I have 3 tables, First one has the product ID and Name, Second one has Supplier ID and name, In the 3rd one i have product ID and Supplier ID. While displaying, i want to replace the product ID and supplier ID in the 3rd table with product name and supplier name from the 1st and 2nd table respectively.
  Please let me know the query for executing it. </p>