Your query ...

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(at)hub(dot)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(at)mpsllc(dot)com]
> > Sent: Friday, April 30, 1999 10:59 AM
> > To: 'pgsql-sql(at)hub(dot)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
>
>