From: AKHILESH GUPTA <akhilesh.davim@gmail.com>
To: pgsql-general@postgresql.org
To: pgsql-sql@postgresql.org
Subject: regarding join
Date: Sat, 25 Mar 2006 12:06:34 +0530
Message-ID: <ad39daf90603242236w1f6a54ecx7ba4d1b24dfdc18c@mail.gmail.com> (raw)
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"
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: akhilesh.davim@gmail.com, pgsql-general@postgresql.org
Subject: Re: regarding join
In-Reply-To: <ad39daf90603242236w1f6a54ecx7ba4d1b24dfdc18c@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox