hard query

Hello everybody, I have a question:


My database is like so:

House(id_house,description)

Property(id_property,id_house,id_person)

Person(id_person,name,description)

Car(id_car,id_person,name)


One person can be the Owner of one or more Houses, and one House can have one or more Owners (People).

One Person can have one or more Cars.


I want do a query which give:

the name of the Cars of the People who are the Owner of the House with the id_house='1'.


Any idea?


Thanks.

Hi lupo ,

try this

SELECT id_car FROM car WHERE id_person IN
(SELECT id_person FROM property WHERE id_house='1' )


let me know if this works