Hi NJ,

Believe it or not, I had that query as well as a 2nd option, and wasn't sure if it was correct.

In the meantime, I know now the complex query s/b:

USE Beerdrinkers

SELECT bar

FROM serves

WHERE beer IN

(SELECT beer FROM likes WHERE drinker = ‘Joe’)

(this is the second one I had)

USE Beerdrinkers

SELECT bar

FROM serves, likes

WHERE serves.beer = likes.beer

AND drinker = ‘Joe’

Thanks for the feedback. I have many more queries I'll be submitting over the next several days.

-Roberta-