🚀 go-pugleaf

My mistake, my program did not include the distinct...
Anyway, my answer with SQL server is 2.By the way,
how can you use rowcount with tadoquery?  my answer is from recordcount...

"YangKai Liu" <yangkai.liu@burkelee.com> wrote:
>
>The answer should be 4, not 2.
>
>The key lies in the inner join of your SELECT DISTINCT statement.  Should you delete the inner join, I think you will have 2 as the answer.
>
>
>"xiao zhen" <zhenx@vip.sina.com> wrote:
>>Is there no one else meet the same problem?
>>Ah.....oh...
>>
>>"xiao zhen" <zhenx@vip.sina.com> д����Ϣ����
>>:3faa11a9$1@newsgroups.borland.com...
>>> I am using BCB6 Enterprise + Update4, connect to oracle 8i by ADO.
>>>
>>> I have 2 tables
>>> depts( deptid Number(10) NOT NULL, deptName varchar2(100) )
>>> has values ( 1, 'aaa' ), (2, 'bbb')
>>>
>>> modality( modalityid Number(4) NOT NULL, deptid Number(10) )
>>> has values ( 1, 1 ), (2, 1), (3, 2), (4,2)
>>>
>>> when I use open a TADOQuery object with SQL as
>>> "select distinct d.deptid, d.deptname from depts d, modality m where
>>> d.deptid = m.deptid"
>>>
>>> the Query->RowCount is 4, not 2!
>>>
>>> when I execute the same command by Oracle SQLPlus, result is 2.
>>>
>>> who can help me?
>>>
>>>
>>>
>>>
>>
>>
>