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.Lawrence@anu.edu.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