regarding join

From: "AKHILESH GUPTA" <akhilesh(dot)davim(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: regarding join
Date: 2006-03-25 06:36:34
Message-ID: ad39daf90603242236w1f6a54ecx7ba4d1b24dfdc18c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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"

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2006-03-25 07:45:54 Re: regarding join
Previous Message Tom Lane 2006-03-25 05:58:15 Re: Query plans for plpgsql triggers

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Kretschmer 2006-03-25 07:45:54 Re: regarding join
Previous Message Tom Lane 2006-03-24 23:48:17 Re: Index on nullable column