我有以下用MySQL Workbench编写的SQL查询:
SELECT
t1.sample_id, t1.v_id, t1.s_type as type, t1.s_fusion, t1.e_fusion, CONCAT(t1.cpt1, ":", t1.ppt1) as point1,
CONCAT(t1.cpt2, ":", t1.ppt2) as point2, t1.s_gene, t1.e_gene, t1.pscore as score, t2.manual_notes
FROM
(
s_samples
WHERE sample_id = 'S0001'
) as t1
INNER JOIN
(
SELECT c.v_id, c.sample_id,
CONCAT(c.sample_id,"(",e.disease,"): ",c.notes) as manual_notes
FROM all_samples e
LEFT JOIN s_samples c
ON e.sample_id=c.sample_id
WHERE c.notes is not null AND c.v_id IN
(SELECT v_id FROM s_samples)
AND c.sample_id = 'S0001'
) as t2
ON t1.v_id = t2.v_id
ORDER BY t1.v_id;
但是,我收到以下错误:对于该服务器版本,“ SELECT”在此位置无效,期望:'(',WITH错误。我对SQL较新,所以我不确定为什么会收到此错误,并且如何解决此问题,我们将不胜感激。
这是无效的SQL:
FROM
(
s_samples
WHERE sample_id = 'S0001'
) as t1
也许您打算:
FROM (SELECT s.*
FROM s_samples s
WHERE s.sample_id = 'S0001'
) t1
当然,这是多余的。您可以只使用表,然后将过滤放在外部WHERE
子句中。
我认为您的错误仅是由于一些一般的混乱而引起的,因为编译器很混乱。
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句