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

2011-06-11 Thread 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 > 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

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

2011-06-11 Thread Claudio Nanni
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" wrote: > Hi > > select * from tablename where fieldname in ('aaa','bbb','ccc','ddd'); > > return only the successful hit. > > How can