具有列compname version的表test和具有列bugid compname的表BugsA 1.2C 1.6C 1.5B 1.61 A2 A3 A3 COutput the compname where version=1.6 and affected by bugid=1 alongwith the first(min) version in which the compon
下图是表与预期输出结果的关联方式。我使用了MySQL版本6.3.3。以下是目前可以实现的目标。select table2.Status as StatusName, count(table1.Status) as NoOfStatus from testingdb.table1, testingdb.table2 where table1.Status=table2.Status group by table1.Status;