Subject Re: [firebird-support] Union statement automatically adds 'DISTINCT'?
Author Hans
Check this

http://www.w3schools.com/sql/sql_union.asp

----- Original Message -----
From: "Dennis McFall" <dennis@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, April 30, 2007 3:44 PM
Subject: Re: [firebird-support] Union statement automatically adds
'DISTINCT'?


> At 04:32 PM 4/30/2007, you wrote:
>>I have two statements:
>>
>>Select [fields] from [Table1]
>>Select [fields] from [Table2]
>>