Results 1 to 2 of 2
Apr 24, 2004, 22:50 #1
- Join Date
- Mar 2004
- united states
- 0 Post(s)
- 0 Thread(s)
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