OK, I'm stumped...

[Ken Ray]

Thanks, Erne... I'll try that...

Ken Ray
Sons of Thunder Software
Email: kray at sonsothunder.com
Web Site: http://www.sonsothunder.com/ 

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of erne
> Sent: Monday, July 07, 2003 4:59 PM
> To: Valentina Developers
> Subject: Re: OK, I'm stumped...
> 
> 
> Hi Ken,
> 
> On Lunedì, lug 7, 2003, at 21:52 Europe/Rome, Ken Ray wrote:
> 
> > SELECT Entities.FirstName,Entities.LastName,
> > Entitites.Company FROM Entities,Marked
> > WHERE Marked.UserLink=1
> >
> > But how do I get the *unmarked* Entities? I can't do this:
> >
> >
> 
> I can think only this way:
> 
> SELECT Entities.FirstName,Entities.LastName,
> Entitites.Company FROM Entities
> WHERE recid not in
> (Select recid from Marked.UserLink=1
> Entitites.Company FROM Entities,Marked
> WHERE Marked.UserLink=1)
> 
> but not sure if Valentina can do this yet
> 
> from the latest docs:
> 
> Version 1.9.8b5-b8 // June 5, 2003
> - [SQL][NEW] BETWEEN operator
> - [SQL][NEW] IN operator
> - [SQL][NEW] WHERE f IN (SELECT ... ) -- first kind of subquery that 
> now support Valentina! :-)
> 
> Cool Runnings,
> Erne.
> 
> |er| musical box
> |ne| a media store
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net 
> http://lists.macserve.net/mailman/listinfo/val> entina
>