SELECT subquery not works or other problem?

[l0rd]

Hi all,

please help me in this,
I have 2 tables: houses and owners
table houses: id,title,picture,price,desription....
table owners: id,user_id,house_id

now making a web based administration, and I need to do the next:
selecting all houseIDs from houses, which houseIDs are NOT assigned to owner (no houseID record in owners table)

SELECT id FROM houses WHERE NOT EXISTS (SELECT house_id FROM owner)

the MySQL version is: 4.0.21
I have looking in google for similar problems, may be the subquery is not supported in this version, or other problem?

I am a newbie and may be it's a simpled way to do this selection.
Thank you for your reply:)