Received: from bjke.com (firewall-user@ganymede.bjke.com [144.210.8.38]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA60427 for ; Fri, 30 Apr 1999 12:02:39 -0400 (EDT) (envelope-from djackson@cpsgroup.com) Received: by bjke.com; id LAA27335; Fri, 30 Apr 1999 11:02:38 -0500 (CDT) Received: from unknown(144.210.12.10) by gauntlet.bjke.com via smap (4.1) id xma026929; Fri, 30 Apr 99 11:01:46 -0500 Received: by cpsmail with Internet Mail Service (5.5.2448.0) id <2D677R0W>; Fri, 30 Apr 1999 11:02:48 -0500 Message-ID: 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 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain 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