Re: Help needed for SQL statement

2005-10-24 Thread Alvaro Cobo
Chen" <[EMAIL PROTECTED]> To: Sent: Monday, October 24, 2005 11:43 PM Subject: Help needed for SQL statement > Hi, > > I have such a situation: > > There is a table with gene_ids and clone_ids. Each gene only resides on a > single clone and each clone may contain multipl

Help needed for SQL statement

2005-10-24 Thread Xiaobo Chen
Hi, I have such a situation: There is a table with gene_ids and clone_ids. Each gene only resides on a single clone and each clone may contain multiple genes. How do would I find how many genes are on each and every clone? Thanks in advance. X.Chen -- MySQL General Mailing List For list arch