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
