<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
I have written following query,<br />
select v.village_name,s.new_surve<wbr />y_no from tbSurvey s inner join tbLACase lc on s.lac_no = lc.lac_no <br />
inner join tbVillage v on v.village_id = s.village_id where lc.lac_no = '1/A-65/1998-99'<br />
<br />
Now there is a column 'possession_date' in tbSurvey.In the above query,I want to show possession_status.<br />
If possession_date is entered in the tbSurvey for that new_survey_no,I want to show 'Yes' else 'No'<br />
<br />
How to do this?
</div>
</div>


Hi Experts,
I have written following query,
select v.village_name,s.new_survey_no from tbSurvey s inner join tbLACase lc on s.lac_no = lc.lac_no 
inner join tbVillage v on v.village_id = s.village_id where lc.lac_no = '1/A-65/1998-99'

Now there is a column 'possession_date' in tbSurvey.In the above query,I want to show possession_status.
If possession_date is entered in the tbSurvey for that new_survey_no,I want to show 'Yes' else 'No'

How to do this?

Help with Sql query(Select)

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.