UNION QUERY

  • Thread starter Thread starter Samora
  • Start date Start date
S

Samora

hi everyone:

I have a Union Query that makes the Union of 3 tables

THeader
TDetail
TFooter

However there is a small problem:

i have 817 rows on TDetail and when i make the Union Query
only appears 779 rows.. I dont understand why.

to make this union query i made the following steps:

1 - concatenate all the fields of the 3 tables in 1 single
field

2 - run the query and only appears 779 rows instead of the
817 rows.


What could be happening? I don't really understand why.

Could someone help me????

Thanks in advance
 
Union queries by default eliminate duplicate rows. To include duplicate
rows, use the ALL keyword ...

SELECT FieldName FROM Table1
UNION ALL SELECT FieldName FROM Table2
 
Back
Top