query help

This seems like such a basic function that I'm sure I am missing something
fundamental. I have a table, say xref, whose columns are primary key values for
other tables. Some of theses keys may be NULL for a given row in xref. I want
to create a query that returns the corresponding entries in the other tables.

xref:
drug_id | function_id|syst_id |text_id
--------------------------
d0001  |      2          |   3      | 3423
d0001  |      5          |           | 5678
d0056  |      3          |   5      |

system_id:
syst_id | syst_desc
--------------
3         | renal
4         | hepatic
5         |  respiratory

clinical_text:
text_id| clinical_text
--------------
3423  | 'some medical mumbo jumbo'
5678  | 'more of the same'

I want the syst_desc and clinical_text (plus other similar data from tables not
shown) given a drug_id and function_id.

Any help?

Thanks a bunch,

Jeff Patterson
The Melanoma Patients' Information Page
http://www.mpip.org