try:SELECT PID, count(IndentItems.Number) FROM IndentItems, Indents WHERE Indents.ID = IndentItems.IID AND IID IN (14,9) group by pid 如果你要把IndentItems.ID 也显示并且显示为'23,42'这种类型的话,就需要写一个字符串合并函数或者用一下临时表了。
select 列1,count(*),min(列3) from 表 group by 列1
To churchatp1 可以,只是再加条件就不行了。 比如 SELECT PID, (SELECT Name FROM Products WHERE ID = PID), count(IndentItems.Number) FROM IndentItems, Indents WHERE Indents.ID = IndentItems.IID AND IID IN (14,9) group by pid
如果你要把IndentItems.ID 也显示并且显示为'23,42'这种类型的话,就需要写一个字符串合并函数或者用一下临时表了。
可以,只是再加条件就不行了。
比如 SELECT PID, (SELECT Name FROM Products WHERE ID = PID), count(IndentItems.Number) FROM IndentItems, Indents WHERE Indents.ID = IndentItems.IID AND IID IN (14,9) group by pid