Subject Re: COUNT discrepancy in DSQL & VIEW
Author csswa
What would be the quickest SQL to compare two tables to find records
that only appear in one or the other?

--- In ib-support@y..., "Jason Chapman (JAC2)" <jason@j...> wrote:
> No idea...
> Have you isolated the row that is different?
> >
> > The DSQL code and VIEW code are identical, yet a COUNT of records
> > returned by the VIEW is 8488 and the COUNT of records in the VIEW
> > 8489. Why is there one less record in the VIEW when the code is
> > identical, as you can see below?