<div>
Thank you for your quick response, Spt_Us . &quot;&nbsp;Are you wanting to 'set' these as yes? &quot;&nbsp;is the scenario that I was aiming for and your solution works perfectly.<br />
<br />
<br />
Regards,<br />
<br />
Wasmithpfs
</div>


Thank you for your quick response, Spt_Us . " Are you wanting to 'set' these as yes? " is the scenario that I was aiming for and your solution works perfectly.


Regards,

Wasmithpfs

<div>
<div class="content wysiwyg-content">
Good Day,<br />
<br />
I need to &nbsp;write a &nbsp;SQL query that goes something &nbsp;like this:<br />
<br />
Select &nbsp;[apples], [oranges], {bananas], &nbsp;[price] from Fruit_Tabletable where <br />
&nbsp;if [price] &nbsp;&gt;0, then [apples] =Yes and oranges= Yes <br />
<br />
I need to only show apples and oranges &nbsp;where the cost is &nbsp;grater than zero and have &quot;Yes&quot; appear in the apples and oranges fields .<br />
<br />
Please advise.<br />
<br />
Thanks,<br />
<br />
wasmithpfs
</div>
</div>


Good Day,

I need to  write a  SQL query that goes something  like this:

Select  [apples], [oranges], {bananas],  [price] from Fruit_Tabletable where 
 if [price]  >0, then [apples] =Yes and oranges= Yes 

I need to only show apples and oranges  where the cost is  grater than zero and have "Yes" appear in the apples and oranges fields .

Please advise.

Thanks,

wasmithpfs

SQL Query If Statement

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.