Two table select - Mailing list pgsql-sql

From Andy
Subject Two table select
Date
Msg-id Pine.LNX.4.05.9902031207090.10174-100000@shell.mpsi.net
Whole thread Raw
List 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


pgsql-sql by date:

Previous
From: Sebestyen Zoltan
Date:
Subject: ...
Next
From: "Jackson, DeJuan"
Date:
Subject: RE: [SQL] Two table select