[GENERAL] regarding join

[AKHILESH GUPTA]

hi all,
below I have created two tables in pgsql with field name as 'name' and 'id' as their datatype 'varchar(15)' and 'integer'.

One of the table is:->
chemical=> select * from test1;
 name  | id
-------+----
 akhil |  1
 b     |  2
 c     |  3
 d     |  4
 e     |  5
 f     |  6
(6 rows)

Another table is:->
chemical=> select * from test3;
 name | id
------+----
 ab   |  1
 cd   |  2
 ef   |  3
 gh   |  4
(4 rows)

i want the output as:->
name  | id
-------+----
 akhil |  1 -----from test1 table
 ab   |  1------from test2 table
 b     |  2-----from test1 table
 cd   |  2------from test2 table
 c     |  3-----from test1 table
 ef   |  3------from test2 table
 d     |  4-----from test1 table
 gh   |  4------from test2 table
 e     |  5-----from test1 table
 f     |  6-----from test1 table

i have tried all the joins but it makes different fields for different tables.
is there any way out for this kind of output??????????????????
(plz reply asap)urgent.

THANKS IN ADVANCE

--
Thanks & Regards,
Akhilesh
S/W Trainee (EDP),
NUCHEM Pvt. Ltd.,
Faridabad(Haryana)
GSM:-(+919891606064)

"FAILURES CAN BE FORGIVEN BUT AIMING LOW IS A CRIME"