a beginner's question
From: Denny <emir_at_paran.com>
Date: Thu, 4 Dec 2008 16:55:56 -0800 (PST)
Message-ID: <63e7afcf-a09d-4a51-af83-6ccfa2ace610@v39g2000pro.googlegroups.com>
Date: Thu, 4 Dec 2008 16:55:56 -0800 (PST)
Message-ID: <63e7afcf-a09d-4a51-af83-6ccfa2ace610@v39g2000pro.googlegroups.com>
CREATE TABLE TEST_A
(
ID VARCHAR2(5),
ID2 VARCHAR2(10),
CONTS VARCHAR2(20)
)
CREATE TABLE TEST_B
(
ID VARCHAR2(5),
ID2 VARCHAR2(10),
CONTS VARCHAR2(20)
)
insert into test_a values ('11111','01','Test Row') insert into test_a values ('11111','02','Test Row')
insert into test_b values ('11111','03','Test Row') insert into test_b values ('11111','04','Test Row')
I have two tables contaning 4 rows above.
And I'd like to show the result below.
How to make SQL query to do that?
Plz let me know?
ID ID2 CONTS 11111 01 Test Row 11111 02 Test Row 11111 03 Test Row 11111 04 Test RowReceived on Thu Dec 04 2008 - 18:55:56 CST