关于group by内部连接mysql

Question

我在MySQL中通过内部连接尝试下面的组。上面写着未知的列名。你能帮我解决这个问题吗。我在内部联接中的查询“select Min(Id)FROM testinbcalls group by lc.DBID”中出现错误，说明“groupby中的unknown column name DBID in the groupby）。如果不允许groupby,是否有其他方法可以修改此查询。我尝试了”select Min(Id)FROM testinbcalls WHERE Id=lc.DBID“而不是group by,但不起作用。我希望不要将检查移到WHERE子句，因为我希望在内部联接本身上筛选记录。有人能帮我吗？谢谢

SELECT DISTINCT ic.Id as `Id`,  lc.DBID,
init.Name as Init,
lc.TargetNumber as PhoneNumber, 
CONCAT(us.FirstName,' ',us.Surname) as UserName,
 iout.Name as Outc FROM 
 testcalls ic
 INNER JOIN testinit init on ic.InitId=init.Id
 INNER JOIN users us on ic.UserId=us.Id
 INNER JOIN testinbcalls lc ON ic.Id=lc.CallId AND  lc.DBID IS NOT NULL AND  ic.Id=(**SELECT Min(Id) FROM testinbcalls group by lc.DBID** )
 INNER JOIN (SELECT MIN(Id) Id FROM  testinbcalls  group by lc.DBID) mincallid ON ic.Id=mincallid.Id
 INNER JOIN icomes iout on ic.OutId=iout.Id 
 WHERE ic.AssignedDateTime between '2015-06-08 00:00:00' and '2015-06-09 23:59:59' ORDER BY Id DESC limit 250;

Answer 1

将其更改为下面，删除表别名lc。这样，您实际上是在引用外部查询表。

INNER JOIN (SELECT MIN(Id) AS MinId FROM  testinbcalls  group by DBID)