Re: Outer Joins, decode, case combinations : Anyone ?

If you really want someone to assit you on this shouldn't you have provided 3 create table statements with insert statements to populate the tables with a minimum amount of data?

You should also always include the Oracle edition and version since features are edition/version dependend.

The solution will depend on how your data is orgranized and how the tables are related. Someone could guess but he or she would be wasting their time if your design was different from what was expected.

HTH -- Mark D Powell -- Received on Wed May 17 2006 - 08:48:48 CDT