_____

From: Uwe Oeder [mailto:uweo@...]
Sent: Tuesday, November 18, 2003 12:05
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Sub-Query Problem



Uwe, looking at the query, I can't understand why you are using a subquery,
I am sure that the where clause could have sufficed, also you are using
joins in the exists clause which is unnecessary and you could improve
performance leaving them out, and also you ought to use the alias prefix for
all selected fields to avoid possible duplicity.

Just interested

Russell



Thanks ! Expected a humongus error and then a typo takes me to the ground.

At 11:20 AM 11/18/2003, you wrote:

>Hello Uwe
>
>At line 12 you have written EXITS, which is not an SQL
>keyword.
>I imagine you wanted to write EXISTS, which would make
>sense.
>
>Best regards
>
>_

[Non-text portions of this message have been removed]