Re: query help

On 2005-04-18, Eugene <epipko_at_hotmail.com> wrote:
> Hi all,
> I need to be able to display all values from two table as follow:
> J100100 100J J01 LP 10 12 11 13 12 14
> J100100 100J EA 17 15 19 13
>
> Here is the setup:
> create table t1
> (
> STYLE_ID CHAR(14),
> COLOR_ID CHAR(6),
> IDENTIFIER_ID CHAR(10),
> PRICE_BRACKET_ID VARCHAR2(5),
> OLD_SKU_PRICE NUMBER(14,4),
> NEW_SKU_PRICE NUMBER(14,4)
> );
>
> create table t2
> (
> STYLE_ID CHAR(14),
> COLOR_ID CHAR(6),
> IDENTIFIER_ID CHAR(10),
> OLD_RET_PRICE NUMBER(14,4),
> NEW_RET_PRICE NUMBER(14,4),
> OLD_SEC_RET_PRICE NUMBER(14,4),
> NEW_SEC_RET_PRICE NUMBER(14,4)
> );
>
> insert into t1 values ('J100100','100J','J01','LP',10,12);
> insert into t2 values ('J100100','100J','J01',11,13,12,14);
> insert into t2 values ('J100100','100J','EA',17,15,19,13);

What's wrong with outer joining these tables?

Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/