DBgrid + ADODC 问题???
想将DBgrid绑定ADODC数据.现在问题是:
举例:有两个表:Table1(TheNo,TheName),Table2(TheNo,Howmuch)
我想在DBgrid中显示 Table1.TheNo,Table1.TheName,Count(Table2.Howmuch)
SQL语句怎么写?
我是这样写的,但是错了.
Select Table1.TheNo,Table1.TheName,Table2.Count(Howmuch) From Table1,
Table2 Group By TheNo Where Table1.TheNo = Table2.TheNo