Add support of Left Joins to Linq Provider

The attached sample identifies a number of issues in the LINQ provider related to the use of the "Join" expression. Specifically when performing outer joins or pre filtering the result set to be join in the join.

for example

select *
from table 1 a
left join table 2 b
on a.id = b.id
and b.start_date < getdate()