select Actions.*, Grants.Period from Actions left join Grants on Actions.ActionID = Grants.ActionID --where Grants.GroupID = @myGroupId