a newbie question regarding data selection
I am beginning to learn SQL and I am stuck trying to perform a simple query. Here are my 3 tables:
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