SQL Query gone wrong.. please help

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