我正在使用HeidiSQl并尝试运行一个查询,我从表1中获取所有用户,然后计算表2中所有匹配的用户。
SELECT DISTINCT problem, title, username, createdate, expiredate
FROM solutionhistory as table1
INNER JOIN (SELECT COUNT(LOGIN_NAME) FROM ra_report_table) as table2
ON table1.username=table2.LOGIN_NAME
WHERE username != 'test'
LIMIT 10
我有点困在哪里我错了!我在table2.LOGIN_NAME
的子句中得到错误未知列。
查询工作,如果我把参考COUNT(LOGIN_NAME)
出来-如果有人能指出我在正确的方向,那将是伟大的!
你的查询在很多层面上都没有意义。我猜你的意图更像这样:
SELECT problem, title, username, createdate, expiredate, table2.cnt
FROM solutionhistory as table1 INNER JOIN
(SELECT LOGIN_NAME, COUNT(LOGIN_NAME) as cnt
FROM ra_report_table
GROUP BY LOGIN_NAME
) as table2
ON table1.username = table2.LOGIN_NAME
WHERE username <> 'test'
LIMIT 10