SQL question

Hi there,

Here's a mini-problem I'm fiddling with. I have a table with *two*
cross-references to the same other table. And I want to make a view (or
do a query) which uses them both. My problem is that so far I can get
one out but not both; it's got to be some syntax thing I'm messing up.

Existing tables:
bond
----
id integer primary key
res1 references residue
res2 references residue
(other stuff)

residue
-------
id integer primary key
code char(3)
(other stuff)

Desired outcome:
nice_human_readable_details_about_bond
-------------
bond.id, bond.res1's code, bond.res2's code, (other details from bond
table)

Cath Lawrence, Cath(dot)Lawrence(at)anu(dot)edu(dot)au
Senior Scientific Programmer, Centre for Bioinformation Science,
John Curtin School of Medical Research (room 4088)
Australian National University, Canberra ACT 0200
ph: (02) 61257959 mobile: 0421-902694 fax: (02) 61252595