Re: query help

Eugene 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);
>
> Thanks,
> Eugene

Then you'd best work at it methinks.

Though before you do you might want to rethink your use of the CHAR data type.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)