hi, i'm trying to write a query to do a group join, but the join condition is NOT simple equality: it's the result of a function, which SQL Server supports, but VB is requiring the Equals keyword and to refer one of the values from each side of the join. Can anyone tell me another way to do this? btw, i'm sure i don't have the rest of the syntax right yet. Dim originalcodeview = From activebranch In Me.ActiveBranches _ Group Join chng In Changes _ On VersionControlPath.IsSubItem(chng.GetCurrentNamespaceForBranchSource,
Read More...