title: Fetch data in the mentioned scenario using a single MySQL Query
body: <p>There are 3 tables with column titles:</p>
  
  <pre><code>course_test_status
  ------------------
  testid
  testname
  testdesc
  
  student_login
  --------------
  stuid
  stuname 
  
  
  student_test_status
  -------------------
  testid
  stuid
  </code></pre>
  
  <p>I want to fetch stuname and testname using <strong>single query</strong> if i already have stuid and testid available. 
  Second thing I would like to know is that which way would be faster? Using select query two times (once with stuid and another with testid) or using a single complex (With Joins or whatever you are suggesting) query?</p>