告诉我表clientescrm不存在。我找不到错误。
select
a.cuit,
a.duplicates,
c.Idclientecrm
from
(
select
replace(replace(cuit, '-', ''),'_','') as cuit,
count(cuit) as duplicates
from clientescrm
group by cuit
having count(cuit) > 1
) a,
clientescrm c
where
a.cuit= replace(replace(c.cuit, '-', ''),'_','')
Thnx的帮助
最佳答案
首先,您应该更改加入表格的方式。这样的查询是编写语法的标准化方法。
SELECT
a.cuit,
a.duplicates,
c.Idclientecrm
FROM
(
SELECT
replace(replace(cuit, '-', ''),'_','') as cuit,
count(cuit) as duplicates
from database.clientescrm
group by cuit
having count(cuit) > 1
) a
JOIN database.clientescrm c ON a.cuit=replace(replace(c.cuit, '-', ''),'_','')
之所以找不到它,是因为大多数原因是当前使用的数据库是错误的,或者更少原因是该表不存在。
确保将
database.
更改为表clientescrm
所在的数据库的名称。关于mysql - SQL:我在此查询中找不到错误,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/20906762/