Thread

Two table select

Andy <alewis@mpsi.net> — 1999-02-03T18:16:03Z

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