0
from foo in context.Foo
join current in context.v_CurrentFooIds on foo.Id equals
   current.CurrentId
join approved in context.v_ApprovedFooIds on foo.VersionIndependentId
   equals approved.VersionIndependentId into leftjoin
from appr in leftjoin.DefaultIfEmpty()
where
   matches.Contains(foo.UniqueFormulaNumber) && !foo.IsTemplate
   && appr == null

I don't understand what into leftjoin does in this context.

I'm lost at equals approved.VersionIndependent into leftJoin from appr in leftjoin.DefaultIfEmpty().

What does this mean?

david.s
  • 11,283
  • 6
  • 50
  • 82
Jack
  • 9,843
  • 23
  • 78
  • 111
  • 2
    `leftjoin` is the intermediate result obtained from joining those three collections above. You could name it whatever you want, the words `leftjoin` have no special significance here. You could have called it, for example, `theResultThatIGotFromDoingThatLastLeftJoin`. – Asad Saeeduddin Apr 17 '15 at 20:49
  • Ah, OK. Thank you Asad for the explanation. That leftjoin really threw me off. – Jack Apr 17 '15 at 21:05

0 Answers0