query help

From: Eugene <epipko_at_hotmail.com>
Date: 18 Apr 2005 14:49:39 -0700
Message-ID: <1113860979.009495.253490@z14g2000cwz.googlegroups.com>

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 Received on Mon Apr 18 2005 - 16:49:39 CDT