Need help with this SQL query

[RavenFrost]

Hello, if you look at the image below you can see an example table. Lets say I want to know which owners own a lizard and a dog. Lets call the table test. Select Owner from test Where Pet... I don't how the rest would go. I'm in a stump here. Any suggestions would help. Thanks.

 

[PHV]

Perhaps this ?
SELECT Owner
FROM test
WHERE Pet IN ('Lizard','Dog')
GROUP BY Owner
HAVING Count(*)=2

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[RavenFrost]

Thanks alot. This is working great up to HAVING COunt(*)=2. I'm getting Incorrect syntax near '*' Any ideas?

 

[r937]

whoa, really? which database system is it? could we see the exact query, and the exact error message?

r937.com | rudy.ca

 

[RavenFrost]

nvm got it to work just had to specify table.column. Thanks!!!!