Duplicates in a query

[Bill Stanton]

I'm experiencing some discrepancies between two
selects that lead me to suspect that one of the
queries is not allowing duplicate records. Case in
point is a Union Select involving like fields from
three different tables. It is the nature of the data
within the selected fields that legitimate duplicates
are likely to occur. So, my question is simply this:
Is there some SQL command I've not yet
encountered that specifies that duplicates are OK?

Thanks,
Bill

 

[Phobos]

UNION SELECT ALL

Will return all records, by default dupes are not included in union queries.

P