title: How do I join tables with a condition using LLBLGen?
body: <p>I have the following Sql Query that returns the type of results that I want:</p>
  
  <pre><code>SELECT b.ID, a.Name, b.Col2, b.COl3
  FROM Table1 a
  LEFT OUTER JOIN Table2 b on b.Col4 = a.ID AND b.Col5 = 'test'
  </code></pre>
  
  <p>In essence, I want a number of rows equal to Table1 (a) while having the data from Table2 (b) listed or NULL if the condition, 'test', doesn't exist in Table2.</p>
  
  <p>I'm rather new to LLBLGen and have tried a few things and it isn't working. I can get it to work if the condition exists; however, when a requirements change came in and caused me to rewrite the query to that above, I'm at a loss.  </p>
  
  <p>Below is the old LLBLGen C# code that worked for existing products but not for the above query:</p>
  
  <pre><code>LookupTable2Collection table2col = new LookupTable2Collection();
  
  RelationCollection relationships = new RelationCollection();
  relationships.Add(LookupTable2Entity.Relations.LookupTable1EntityUsingTable1ID, JoinHint.Left);
  
  IPredicateExpression filter = new PredicateExpression();
  filter.Add(new FieldCompareValuePredicate(LookupTable2Fields.Col5, ComparisonOperator.Equal, "test"));
  
  table2col.GetMulti(filter, relationships);
  </code></pre>
  
  <p>Table 1 has 3 records in it.  I need the 3 records back even if all items from Table 2 are NULL because the condition doesn't exist.  Any ideas?</p>