From: S S Mani <ssmani@stockholding.com>
To: jt-kirkpatrick@mpsllc.com
To: pgsql-sql@hub.org
To: djackson@cpsgroup.com
Subject: Your query ...
Date: Mon, 29 Nov 1999 14:44:51 +0530
Message-ID: <3842440B.2AA9E04F@stockholding.com> (raw)
Hi
Maybe your query has already been solved!
If not then pl. try it here :-
The solution given by Jackson DeJuan will work if the datatypes &
parameters of both fields are the same.
If they are not then try :-
select subnum||' ' /* The no. of spaces between the single quotes
should be equal to length of col vnum */
from subs
union
select ' '||vnum /* The no. of spaces between the single
quotes should be equal to length of col subnum */
from vend
=======================**************=======================================
> RE: [SQL] combining a single field in two tables into one column.
>
>
>
> From: "Jackson, DeJuan"
> To: JT Kirkpatrick , "'pgsql-sql@hub.org'"
> Subject: RE: [SQL] combining a single field in two tables into
> one column.
> Date: Fri, 30 Apr 1999 11:02:47 -0500
>
>
>
> try:
> select subnum from subs
> union all
> select vnum from vend;
> -DEJ
>
> > -----Original Message-----
> > From: JT Kirkpatrick [SMTP:jt-kirkpatrick@mpsllc.com]
> > Sent: Friday, April 30, 1999 10:59 AM
> > To: 'pgsql-sql@hub.org'
> > Subject: [SQL] combining a single field in two tables into one
> > column.
> >
> > i come seeking wisdom. . .
> >
> > i have two tables, one for subcontractors and another for vendors.
> subs
> > have a primary key of subnum int4, vendors a primary key of vnum
> int4. i
> > need to create a query that allows me to see a complete list of
> these
> > numbers in a single column. for instance, subnum (all begin with 9)
> has
> > values 90001, 90002, 90003 (only three records for the example), and
> vnum
> > (all begin with 2) has values 20001, 20002. i'd like my query
> result to
> > show:
> >
> > 90001
> > 90002
> > 90003
> > 20001
> > 20002
> >
> > this does NOT work: select a.subnum as z, b.vnum as z from subs a,
> vend
> > b;
> > NOR does: select a.subnum, b.vnum from subs a, vend b;
> >
> > by the way, the two tables DO NOT relate to each other (i.e., 90001
> does
> > not have anything to do with 20001). . .
> >
> > TIA, jt
>
>
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: ssmani@stockholding.com, jt-kirkpatrick@mpsllc.com, pgsql-sql@hub.org, djackson@cpsgroup.com
Subject: Re: Your query ...
In-Reply-To: <3842440B.2AA9E04F@stockholding.com>
References: <3842440B.2AA9E04F@stockholding.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