Thread: getting counts . .please help
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
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