From: "Lee Jenkins" <lee@...>

>
> Hi all,
>
> I've done queries like the one below many times and have never had a
> problem
> until now.
>
> SELECT oid,
> region_oid,
> active_date,
> address1,
> address2,
> city,
> province,
> postal_code,
> user_email,
> user_first,
> user_last,
> is_active,
> display_name
> FROM
> league_user
> WHERE
> (LEAGUE_USER.OID NOT IN
> ('SELECT
> te.player_oid
> from tourney_entry te
> where
> te.EVENT_OID = ''B423D283-5856-4CBC-9FF4-5D4BC413C061'''))
> AND
> LEAGUE_USER.FIRST_UPPER LIKE 'LEE%'
> ORDER BY user_first, user_last
>
>

Not sure, since it looks like a valid query, but I would first try using an
alias on the league_user table. Mixing alias and non-alias tables in a query
is not good practice and could cause problems.

Woody (TMW)