Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Stefan Wuebbe
  Where is Stefan Wuebbe?
 Hamburg
 Germany
 Stefan Wuebbe
 To: mk sharma
  Where is mk sharma?
 mumbai
 India
 mk sharma
 Tags
Subject: RE: Select Sql
Thread ID: 416083 Message ID: 416088 # Views: 37 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Sunday, December 21, 2014 7:41:31 AM         
   


> > That looks as if you want an "And" condition instead of the implicit "Or"?
> >
> >
> > Select * From junk1 Where film_id In (Select film_id From junk1 Where person_id = 45) And film_id In (Select film_id From junk1 Where person_id = 38)
> > 

> >
> >
> >
> > hth
> > -Stefan
> >
> >
>
> Thank you,
> Perfect!
>
> Is this possible with Single Select Sql, without "In" clause or with Single "In" clause ?
>
>
> Warm Regards,
> mk.


Hmmm -- I would say "No", but of course one should never say never, and later someone else might come up with a surprise? :-)



Regards
-Stefan

ENTIRE THREAD

Select Sql Posted by mk sharma @ 12/21/2014 6:32:43 AM
RE: Select Sql Posted by Stefan Wuebbe @ 12/21/2014 6:53:37 AM
RE: Select Sql Posted by mk sharma @ 12/21/2014 7:02:21 AM
RE: Select Sql Posted by Stefan Wuebbe @ 12/21/2014 7:41:31 AM
RE: Select Sql Posted by mk sharma @ 12/21/2014 8:10:07 AM
RE: Select Sql Posted by Vilhelm-Ion Praisach @ 12/21/2014 12:12:33 PM
RE: Select Sql Posted by mk sharma @ 12/21/2014 5:24:53 PM
RE: Select Sql Posted by Anders Altberg @ 12/21/2014 10:58:37 PM