I Think the problem is the quotte before SELECT and after double quotte ".


(LEAGUE_USER.OID NOT IN (*'*SELECT te.player_oid from tourney_entry te where
te.EVENT_OID = ''B423D283-5856-4CBC-9FF4-5D4BC413C061''*'*))


The problem is this *' *quotte



**
2010/7/1 Lee Jenkins <lee@...>

>
>
> Helen Borrie wrote:
> >
> >
> > At 05:31 AM 2/07/2010, you wrote:
> >
> > >Hi all,
> > >
> > >I've done queries like the one below many times and have never had a
> > problem
> > >until now.
> >
> > Are you still using Fb 1.5? If not, it would be beneficial to study the
> > release and compatibility notes...
> >
>
> Never mind. Got it. Not Exists did the trick.
>
> Thanks again!
>
> --
> Warm Regards,
>
> Lee
>
>
>

--
Ricardo...


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