OK, I'm stumped...

[erne]

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