Re: getting counts . .please help

I'm thinking that you're asking from something along
these lines:

SELECT count(*)
FROM gob
WHERE gid IN
(SELECT gid FROM comb2
  WHERE seq_id IS NOT NULL);

This will give you a count of gid instances in table
'gob' that are also in the table 'comb2' with at least
one seq_id assigned.

Sub-selects - gotta love 'em.

Hope this helps.

--- Srinivas Iyyer <srini_iyyer_bio@yahoo.com> wrote:

> 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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map
> settings
>


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