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
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