title: Write a select query for getting table value using another table field value
body: <p>I am having two tables student and guardian table</p>
  <p>So I want to write a query to get the guardian name guardian age from guardian using stu_uid retrievd from student table using stu_id which will be static</p>
  <pre><code>Select guardian_nm,guardian_age 
  from guardian 
  where stu_uid=(select stu_uid from student where stu_id=1)
  </code></pre>
  <p>I wrote a query like above but not working</p>
  <p>Can anyone pls help me</p>
  <p>Thanks in advance</p>