Re: [XMLPipeDB-developer] System table subquery

[Richard B. <rbr...@gm...>]

Spent the weekend reviewing sql and I have achieved some clarity.

I'm still working through things but not at least I have better context and
can ask intelligent questions.

The sub query was a big help, I'm not sure how long it would have taken me
to do all the joins using ON to return "hjid | species name"

Dondi - I'll stop by after theory tomorrow to discuss further.

Thanks.

Richard

On Thu, Sep 8, 2011 at 5:24 PM, John David N. Dionisio <do...@lm...>wrote:

> 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
>
>
>
>
>
> ------------------------------------------------------------------------------
> Why Cloud-Based Security and Archiving Make Sense
> Osterman Research conducted this study that outlines how and why cloud
> computing security and archiving is rapidly being adopted across the IT
> space for its ease of implementation, lower cost, and increased
> reliability. Learn more. http://www.accelacomm.com/jaw/sfnl/114/51425301/
> _______________________________________________
> xmlpipedb-developer mailing list
> xml...@li...
> https://lists.sourceforge.net/lists/listinfo/xmlpipedb-developer
>