<p>I'm having some trouble figuring out how to use more than one left outer join using LINQ to SQL.  I understand how to use one left outer join.  I'm using VB.NET.  Below is my SQL syntax.</p>

<p><strong>T-SQL</strong></p>

<pre><code>SELECT
    o.OrderNumber,
    v.VendorName,
    s.StatusName
FROM
    Orders o
LEFT OUTER JOIN Vendors v ON
    v.Id = o.VendorId
LEFT OUTER JOIN Status s ON
    s.Id = o.StatusId
WHERE
    o.OrderNumber &gt;= 100000 AND
    o.OrderNumber &lt;= 200000
</code></pre>

I think you should be able to follow the method used in
this
post.  It looks really ugly, but I would think you could do it twice and get the result you want.
I wonder if this is actually a case where you'd be better off using
```
DataContext.ExecuteCommand(...)
```
instead of converting to linq.