title: Not sure how to use Decode, NVL, and/or isNull (or something else?) in this situation
body: <p>I have a table of orders for particular products, and a table of products that are on sale. (It's not ideal database structure, but that's out of my control.) What I want to do is outer join the order table to the sale table via product number, but I don't want to include any particular data from the sale table, I just want a Y if the join exists or N if it doesn't in the output. Can anyone explain how I can do this in SQL?</p>
  
  <p>Thanks in advance!</p>