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>


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 Row
Received on Thu Dec 04 2008 - 18:55:56 CST

Original text of this message