a newbie question regarding data selection

[davidklonski]

Hello

I am beginning to learn SQL and I am stuck trying to perform a simple query. Here are my 3 tables:

People:
ID: int(5)
Name: varchar(255)

Pets:
ID: int(5)
Name: varchar(255)
Type: varchar(255)

Ownership:
Person_ID int(5)
Pet_ID int(5)

The Ownership table makes the connection between a person and a pet.
I would like to extract the IDs of all the people who don't own a pet of type 'dog'. They are allowed to own pets of other types of course.

Please help, I am stuck with the mysql manual and going nowwhere

thanks

[Pig]

I believe this is what you want.

SELECT 
  * 
FROM 
  people 
LEFT JOIN ownership ON ownership_person_id=people_id
LEFT JOIN pets ON pets_id=ownership_pets_id
WHERE 
  pets_type != 'dog'