QUERY sql database
<p>PLEASE HELP FOR A QUERY</p>

<p>My <code>Student_Master Table</code>:-</p>

<pre><code>ID Name  
1  AAA
2  BBB  
3  CCC
4  DDD

My Student Details Table

ID MastID Address
1   1     Address 1   
2   2     Address 2
</code></pre>

<p>Now I have a gridview which is bound to Student master table, now I want a custom column in my gridview called so that "The students who have address there status should be "Address Present" and for the student whose address is not present in table for them there status would be "Address NOT Present"
Eg. </p>

<pre><code>ID Name  Status
1  AAA   Address Present
2  BBB   Address Present 
3  CCC   Address NOT Present  
4  DDD  Address NOT Present
</code></pre>
