Re: How to find values which do not return any tuple in "IN" clause

[Claudio Nanni]

Sorry but my mail was in "sending state" since last night, and only now was
sent.

Ignore it.

Claudio


2011/6/11 Claudio Nanni <claudio.nanni@stripped>

> Hi Fahim,
>
> Could you please explain better what you mean exactly?
> I think the question is not very clear.
> Thanks
>
> Claudio
> On Jun 11, 2011 12:36 AM, "Fahim Mohammad" <fahim.md@stripped> wrote:
> > Hi
> >
> > select * from tablename where fieldname in ('aaa','bbb','ccc','ddd');
> >
> > return only the successful hit.
> >
> > How can I know how many out of four ('aaa','bbb','ccc','ddd') resulted in
> a
> > miss OR which values do not return any tuple.
> >
> > Thanks
> >
> > Fahim
>



-- 
Claudio