pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chris Bitmead <chris.bitmead@bigfoot.com>
To: 'pgsql-sql@hub.org' <pgsql-sql@hub.org>
Subject: Re: [SQL] combining a single field in two tables into one column.
Date: Fri, 30 Apr 1999 16:15:36 +0000
Message-ID: <3729D728.281FBCDC@bigfoot.com> (raw)
References: <01BE9300.DA3BFC80.jt-kirkpatrick@mpsllc.com>

You need something along the lines of 
SELECT subnum FROM subs UNION SELECT vnum FROM vend;


JT Kirkpatrick wrote:
> 
> 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

-- 
Chris Bitmead
http://www.bigfoot.com/~chris.bitmead
mailto:chris.bitmead@bigfoot.com



view thread (4+ messages)

Message-ID: <3729D728.281FBCDC@bigfoot.com>
Permalink:  ../3729D728.281FBCDC@bigfoot.com/
Also on:    postgresql.org/message-id/3729D728.281FBCDC@bigfoot.com

 · 

reply

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: chris.bitmead@bigfoot.com, pgsql-sql@hub.org
  Subject: Re: [SQL] combining a single field in two tables into one column.
  In-Reply-To: <3729D728.281FBCDC@bigfoot.com>
  References: <01BE9300.DA3BFC80.jt-kirkpatrick@mpsllc.com> <3729D728.281FBCDC@bigfoot.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