[go] wild goose chase

[Sue Rhee]

I've been trying to do a couple of SQLs using Goose and it's timing out.
Can someone please run the following SQL for me please?

SELECT evidence.code, count(distinct association.id) AS
evidence__association_count FROM association, evidence where
evidence.association_id = association.id GROUP BY evidence.code

Thanks,
Sue


-- 
Sue Rhee
Staff Scientist
Carnegie Institution, Department of Plant Biology
260 Panama Street, Stanford, CA 94305
Email: (650) 325-1521 x251
Fax: (650) 325-6857