SQL Query gone wrong.. please help - Mailing list pgsql-novice

Dear group,

I have three tables:


table: sequence
seq_id | seq_name | seq_refseq
     1 | EI24     | NM_004879.3
     2 | NDRG2    | NM_201540.1
     3 | RARRES2  | NM_002889.2



table: gos
gos_id | go_id | go_term | go_class
11041 | GO:0006807 | nitrogen compound metabolism |P
11049 | GO:0004263 | chymotrypsin activity| F

table : go_seq


gos_id | seq_id
  13819 |  11408
  13819 |  11950
  13819 |  12822
  13819 |  11350




I want to query go_seq table, giving seq_name = 'EI24'


select seq_name, go_term
from sequence, gos, go_seq


where  go_seq.seq_id = go_seq.gos_id and
           sequence.seq_id = sequence.seq_name and
            sequence_seq_name = 'EI24';



I am wrong here,  unable to get it correctly.  Could
you please help here.


thanks
srini

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com