[XMLPipeDB-developer] System table subquery

[John D. N. D. <do...@lm...>]

Hi Rich,

As discussed in our meeting, here is a first step toward the new system table query:

	SELECT entrytype.hjid, organismnametype.value FROM entrytype INNER JOIN organismtype ON (entrytype.organism = organismtype.hjid) inner join organismnametype on (organismtype.hjid = organismnametype.organismtype_name_hjid) INNER JOIN dbreferencetype ON(dbreferencetype.organismtype_dbreference_hjid = organismtype.hjid) WHERE dbreferencetype.type = 'NCBI Taxonomy' and (id = '90371'); 

(substitute the "id = " clause accordingly)

John David N. Dionisio, PhD
Associate Professor, Computer Science
Associate Director, University Honors Program
Loyola Marymount University