title: Fetching results from one table and put the corresponding values in another table
body: <p>I was searching for a result, but I didn't find proper solutions. </p>
  
  <p>So, I will put my problem across. Please tell, if its already listed in any of the topics !</p>
  
  <p>I have one table, table123, which has columns like, </p>
  
  <pre><code>Old_variable
  New_Variable
  ValueDesc
  Default_Value
  </code></pre>
  
  <p>There is another table, t6, which has columns like, </p>
  
  <pre><code>template_code
  Paragraph_code
  Old_Var
  New_var
  </code></pre>
  
  <p>This table has values, multiple times, the same paragraph code, in other templates.</p>
  
  <p>Now, I want to join these two tables, based on New_variable and New_var and I want a result like, which has template_code, paragraph_code, New_variable and the corresponding values of variable description and default value. And only the paragraphs, should be present only once. If it is present in one template, it need not come in other template.</p>
  
  <p>Is this a possible query through MySQL?</p>