" UNION ALL does not do a DISTINCT operation. "

It's OK. It's Friday :-)

Arno Brinkman wrote:

>As another follow up, thomas forgot the UNION ALL in his rewrite ;-)
>
>
>SELECT
> LocationId, LocationName
>FROM
> Locations
>UNION ALL
>SELECT
> -5, Cast('(new location)' as VarChar(64))
>FROM
> RDB$DATABASE
>ORDER BY
> 2
>
>
>
>Regards,
>Arno Brinkman
>ABVisie
>
>-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>Firebird links :
> http://www.firebirdsql.com
> http://www.firebirdsql.info
> http://www.fingerbird.de/
> http://www.comunidade-firebird.org/
>
>
>Nederlandse firebird nieuwsgroep :
>news://80.126.130.81
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://sourceforge.net/projects/dbexpressplus