Complex left joins

Complex left joins

Chandler242Chandler242 Posts: 36Questions: 12Answers: 0


I understand that "Complex left joins" allows complex raw conditions but doesn't allow query parameters. On the other hand ".Where" method can do the same things only over multiple left-joins and accept parameters. My question is when there would be a need to use the "Complex left joins", particularly the SQL engine will optimize the queries anyway.

Thank you,

John Li


  • allanallan Posts: 61,669Questions: 1Answers: 10,096 Site admin

    A sub-select on the join is the most common use case I'm aware of. Also multiple conditions for the join is something I've seen used a fair bit.

    In many cases you are right a WHERE statement would do, but not always, which is why we added that ability to the join statement.


Sign In or Register to comment.