Re: [XMLPipeDB-developer] System table subquery

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

Solid progress made and I now have a compilable working copy.

I'm now working through how to plug the results of the query into the proper
slots under the while loop. I had stumbled on an error where I was supplying
the column name instead of the actual data from the tuple. Solved that and
am hoping the current export will be the last before I commit to
sourceforge.

Richard


On Mon, Sep 12, 2011 at 10:59 PM, Richard Brous <rbr...@gm...> wrote:

> 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
>>
>
>