 <p>You should be able to use the <a href="http://www.techonthenet.com/oracle/functions/case.php" rel="nofollow noreferrer"><code>CASE</code></a> construct, and it would look something like this:</p> <pre><code>select order.foo, case when sale.argle is null then 'N' else 'Y' end from order left join sale on order.product_number = sale.product_number; </code></pre>