mysql - 选择具有连接语法错误的查询

Question

SELECT SampleSheet.Id,SampleSheet.Sample_Complete,SampleSheet.SampleName,"
                + "count(Job.sampleId) AS NumberOfSamples FROM (SampleSheet "
                + "LEFT JOIN Job ON SampleSheet.Id = Job.sampleId) "
                + "WHERE SampleSheet.Sample_Complete=?"
                + "GROUP BY SampleSheet.Id

任何人都可以告诉我这个查询有什么问题吗？我收到语法错误。

如果我不使用 Where 条件，它工作正常。但是我需要获取样本完整的行。

SELECT SampleSheet.Id,SampleSheet.Sample_Complete,SampleSheet.SampleName,count(Job.sampleId) AS NumberOfSamples FROM (SampleSheet LEFT JOIN Job ON SampleSheet.Id = Job.sampleId) GROUP BY SampleSheet.Id

Answer 1

有几个建议。这似乎是 WHERE 子句之后的空间问题

            + "WHERE SampleSheet.Sample_Complete=?"
            + "GROUP BY SampleSheet.Id

代替

            + "WHERE SampleSheet.Sample_Complete=? "
            + "GROUP BY SampleSheet.Id

您也可以删除 ( 就在 FROM 之后，显然 ) 也是如此。这不是必需的。

 FROM (SampleSheet "
            + "LEFT JOIN Job ON SampleSheet.Id = Job.sampleId) "