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.
