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