Re: S.O.D.A. database Query API - call for comments

Lee Fesperman <firstsql_at_ix.netcom.com> wrote in <3AEB2DB6.164F_at_ix.netcom.com>:

>Carl Rosenberger wrote:
>>
>> Please feel free to write an SQL statement for the following example,
>> by using standard facilities if you wish:
>>
>> class Person
>> CommunicationMedium[] comMedia;
>> class CommunicationMedium
>> class Phone extends CommunicationMedium
>> class MobilePhone extends Phone
>>
>> "I would like to know all Persons, that don't have a mobile phone."
>
>If you insist...
>
>SELECT *
>FROM person
>WHERE person_id NOT IN
> (SELECT person_id
> FROM person_comm_medium
> WHERE type = 'mobile phone')

Consider another question using the same "schema": "I would like to know who owns this mobile phone I just found"

I know how to do this query in SQL, but how do I do it in S.O.D.A? Must I write a program?

/Per Schröder Received on Sun Apr 29 2001 - 00:08:46 CEST