Re: [Gmod-schema] identification of root term in cv

[chris m. <cj...@fr...>]

Like this (from godb-bridge):

SELECT * FROM cvterm WHERE cvterm_id NOT IN (SELECT DISTINCT  
subject_id FROM cvterm_relationship) AND is_obsolete = 0 AND  
is_relationshiptype = 0

On Jul 20, 2006, at 1:39 AM, Kevin Manansala wrote:

> Good day,
>
> I would like to know how to identify root cvterms of a cv in the  
> Chado schema?
>
> Thank you very much in advance.
>
> Cheers!
>
> -- 
> Kevin L. Manansala
> BS Computer Science
> UP Diliman
>
> "I'm the best there is at what I do!" - wolverine
> ---------------------------------------------------------------------- 
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys -- and earn  
> cash
> http://www.techsay.com/default.php? 
> page=join.php&p=sourceforge&CID=DEVDEV________________________________ 
> _______________
> Gmod-schema mailing list
> Gmo...@li...
> https://lists.sourceforge.net/lists/listinfo/gmod-schema