SELECT
 Hunt.ID
,Hunt.MemberID
,Hunt.PropertyID
,Hunt.HuntDate
,Hunt.SeasonID
,Property.ID
,Property.Lat
,Property.Long
,Property.Zoom
,Invited.ID
,Invited.HuntID
,Invited.MemberID
,Invited.SeasonID
FROM Hunt
INNER JOIN Property ON Hunt.PropertyID = Property.ID
LEFT OUTER JOIN Invited ON Hunt.ID = Invited.HuntID
WHERE Hunt.MemberID = @MemberID
OR Invited.MemberID = @MemberID