I'm trying to connect to a sql server remotely and getting this:

DB-Lib error message 20017, severity 9:

Unexpected EOF from the server

Net-Lib error during Operation now in progress

Error 36 -...

thanks, I guess I don't understand why OR's take more time than AND's, but I'll take your word for it and investigate more on my own. I understand what...

So I came up with this:

SELECT Distinct VenueID

FROM VirtualVenues V join (Meetings M join Reservations R ON ReservationMeetingID=MeetingID) on M.VirtualVenue=VenueID

WHERE V.IncludeRandom = 1

AND V.Inactive = 0

AND V.SiteID=39

and...

Thanks everyone, I take all these comments to heart. I'm not sure I understand the advantages/disadvantages of various joins, is there an online resource that discusses the related concepts?...