Mr Kaufmann, use the Firebird-support mailing to
support questions.

On Fri, 10 Jun 2005 06:49:52 -0000, Christian Kaufmann wrote:

>The following query works on my database:
>
>select achssegmentid from achssegment union select gebietid from
>gebiet
>
>But if I use it like this I receive an error
>
>select count(*) as N, ACHSSEGMENTID from DATA_FEA
>where
> not (ACHSSEGMENTID in
> (select achssegmentid from achssegment union select gebietid from
>gebiet))
>group by ACHSSEGMENTID
>
>
>SQL error code = -104 Token unknown - line 4, char 44 union
>
>Do I need a view for the union ?
>
>cu Christian
>
>
>
>
>Community email addresses:
> Post message: Firebird-general@yahoogroups.com
> Subscribe: Firebird-general-subscribe@yahoogroups.com
> Unsubscribe: Firebird-general-unsubscribe@yahoogroups.com
> List owner: Firebird-general-owner@yahoogroups.com
>
>Shortcut URL to this page:
> http://www.yahoogroups.com/community/Firebird-general
>Yahoo! Groups Links
>
>
>
>
>
>
>