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 -- ================================================================== Michiel Van Bel PhD student Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM mibel@psb.ugent.be http://www.psb.ugent.be ==================================================================