so what is the solution... Michiel Van Bel wrote:
ok problem solved,
apparently i've been sleeping through the DB-practice sessions :D
Michiel Van Bel wrote:
Hey,
can somebody point out what is wrong with this query? I do not really see anything wrong with the syntax, but apparently, there is :(
SELECT `common_name`, `type`, count(`gene_id`) AS `count` FROM `annotation` WHERE `species`='ath' JOIN annot_sources ON annotation.source_key = annot_sources.pkey GROUP BY source_key,type;
Sql is complaining about the syntax, so you can assume that all the table and column names are correct.
Michiel
PS: The winner can go get a free hotdog downstairs :p
-- ================================================================== Ward Blondé wablo@psb.ugent.be PhD student Tel:+32 (0)9 331 38 24 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM http://www.psb.ugent.be/cbd/people_ward_blonde.php ==================================================================