Re: CAP Query Language: Proposition to query properties with multiple occurrences

["John Stracke" <jstracke@xxxxxxxxxxxxxxxxxxxx>]

>The query: "All VEVENTs accepted by user1 and user2"
>
>Could be written as follows:
>
>  SELECT * FROM  VEVENT 
>    USING ATTENDEE AS ATT1,
>          ATTENDEE AS ATT2
>    WHERE ATT1.PARTSTAT = 'ACCEPTED' AND ATT1 = 'user1@xxxxxxxxxxx' AND
>          ATT2.PARTSTAT = 'ACCEPTED' AND ATT2 = 'user2@xxxxxxxxxxx'

Possibly.  On a CS with a SQL backend, this would then translate into 
joining with the ATTENDEE table twice.  Might not be efficient, but it's 
straightforward.

Bruce, is this something that your engine could reasonably handle?

/===========================================================\
|John Stracke                   |Principal Engineer         |
|jstracke@xxxxxxxxxxxxxxxxxxxx  |Incentive Systems, Inc.    |
|http://www.incentivesystems.com|My opinions are my own.    |
|===========================================================|
|We must be devious, cunning, inventive... too bad we're us.|
\===========================================================/