Not sure how to use Decode, NVL, and/or isNull (or something else?) in this situation

Posted by RSW on Stack Overflow See other posts from Stack Overflow or by RSW
Published on 2010-05-13T19:40:40Z Indexed on 2010/05/13 19:44 UTC
Read the original article Hit count: 149

Filed under:
|
|
|
|

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?

Thanks in advance!

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about sql