Hello all
I just suscribed to this list.
I am a scientist working in Strasbourg (France) on problems related to gene
expressions.
I have a first question : I am comparing 2 tables, "gene-length" and
"150genes".
mysql> describe 150genes;
+--+--+--+-+-
On Thursday 13 July 2006 14:19, Peter Brawley wrote:
> Jean-Claude
>
> >But how to list all AC in Chimeric_Cluster_IDs _ABSENT_ from the
> > gene_length table, this one for instance :
> >mysql> select Chr_Name, Unigene_ID from gene_length where
> >Unigene_ID='Mm.371574';
> >Any idea ?
>
> That is c
On Thursday 13 July 2006 16:52, Peter Brawley wrote:
> Jean-Claude
>
> >I agree that LEFT JOIN is probably part of the solution. But the command
> > you suggest do not work, perhaps because several Chimeric_Cluster_IDs and
> > Unigene_ID are void or NULL. I want a list of AC from
> > Chimeric_Clus
