Subject | Re: a view, a select - same DML, different record count ! |
---|---|
Author | t541hoo |
Post date | 2002-05-14T15:50:23Z |
Is the reported recordcount for the SELECT... also the
number of outputrecords?
I suspect that the SELECT... reports the number of inputrecords
before the GROUP BY.
The VIEW acts as a new table and thereby a SELECT... on the view
will report the number of records in that new table (the number of
records after the GROUP BY is executed).
With kind regards, Eric-Jan
number of outputrecords?
I suspect that the SELECT... reports the number of inputrecords
before the GROUP BY.
The VIEW acts as a new table and thereby a SELECT... on the view
will report the number of records in that new table (the number of
records after the GROUP BY is executed).
With kind regards, Eric-Jan