dear group,
I have a table:
Table: gob
gid | goid | gon
|gonms
-----+------------+----------------------------------+
2146 | GO:0000005 | ribosomal chaperone activity |
MF
2147 | GO:0000006 | zinc uptake transporter activity |
MF
2148 | GO:0000007 | zinc ion transporter activity |
MF
Table comb2:
c2id | gid | seq_id
--------+-------+--------
171912 | 4867 | 41087
171913 | 6844 | 54392
171914 | 3334 | 50007
171915 | 15562 | 38416
seq_id | seq_refseq | seq_gname
--------+--------------+-----------------
33014 | NM_025196 | GRPEL1
33015 | NM_007186 | CEP2
33016 | NM_018148 | LINS1
33017 | NM_199166 | ALAS1
33018 | NM_001029946 | C1orf178
seq_id and gid are in bridge table com2.
My question is :
I want to take each entry from table gobe (gid) and
count to how many seq_id is connected.
could any one help me please.
Thanks
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com