Your query will not work in sql server..also you dont need subquery for this..

try this..

select bar

from serves join likes on

serves.bar = likes.bar

and likes.drinker = 'joe'

some basic information about subqueries is here

http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=74