Two table select

From: Andy <alewis(at)mpsi(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Two table select
Date: 1999-02-03 18:16:03
Message-ID: Pine.LNX.4.05.9902031207090.10174-100000@shell.mpsi.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I have two queries that I'd like to make as one. Here are the queries:

select * from referral where oid = $some_oid

select bldgname from apts where bldgnum = 'rbldg1'

I am trying to get the bldgname from the apts table and want to get all of the
bldgname's including rbldg2, rbldg3, rbldg4. Trying to do it in one select
statment, is this possible?

table = referral
+----------------------------------+----------------------------------+-------+
| rstate | varchar() | 2 |
| rrif | varchar() | 10 |
| rphone | varchar() | 20 |
| rfirstname | varchar() | 20 |
| rlastname | varchar() | 25 |
| rbldg1 | varchar() | 10 |
| rbldgcomment1 | text | var |
| rbldg2 | varchar() | 10 |
| rbldgcomment2 | text | var |
| rbldg3 | varchar() | 10 |
| rbldgcomment3 | text | var |
| rbldg4 | varchar() | 10 |
....
+----------------------------------+----------------------------------+-------+

Thanks in advance

Andy

Browse pgsql-sql by date

  From Date Subject
Next Message Jackson, DeJuan 1999-02-03 18:53:01 RE: [SQL] Two table select
Previous Message Viorel Anghel 1999-02-03 17:49:36 how to use arrays?