Don't put the WHERE clause in front of the JOIN :) -Kenny On Thu, 29 May 2008, Ward Blondé wrote:
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
--