Re: Duplicate record dropped in SQL UNION query...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks for your help, Mark! I searched for help on this issue using
F1, but was unsuccessful. Now I know!
-
David
===========================
Mark Burgum wrote:
that is because union is by default distinct. you need to say 'union all' to
get the behaviour you are asking for.
"David" <David.Aman@xxxxxxxxx> wrote in message
news:1154918374.944418.45950@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi --
-
I have 8 tables in a directory. One of the tables has a duplicate
record. The number of records for all 8 tables, including the
duplicate record, is 13,021
-
I joined the 8 tables using SQL UNION. One of the instances of the
duplicate record is NOT part of the resulting cursor. The total number
of records in the cursor is 13,020.
-
How did this happen?
-
Thanks for any help.
David


.

Relevant Pages

  • Re: How to clone a TADOQuery
    ... >For TClientDataset, there is a method CloneCursor which can clone a cursor, ... >Is there similar method in TADOQuery? ... >I want to use this method to check duplicate record, For some reason, I ...
    (borland.public.delphi.database.ado)
  • How to clone a TADOQuery
    ... For TClientDataset, there is a method CloneCursor which can clone a cursor, ... Is there similar method in TADOQuery? ... I want to use this method to check duplicate record, For some reason, I ...
    (borland.public.delphi.database.ado)