Complex left joins

Chandler242

Hello,

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

allan

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.

Allan