title: selecting multiple columns from multiple tables in mysql
body: <p>below is my query</p>
  
  <pre><code>select p.problem_id,
         p.problem_title,
         p.description,
         paps.problem_external_source_id, 
         paps.problem_and_problem_source_id 
    from problem_backup p,
         problem_and_problem_source paps 
   where p.problem_id=paps.problem_id and paps.free_user_id!='null';
  </code></pre>
  
  <p>My question is how to select another table columns based on the retrieved columns(i.e in my query i want to select some more columns from another table based on problem_and_problem_source_id) that is retrieved ,i want to do it in the same query,can we do the whole work in procedures..</p>