{This new question has been split away from the original thread (Find the lowest value in an array of results within a SELECT statement... possible?) as threads may only contain a single question - NeoPa.}
I've realized I should probably be using a LEFT JOIN instead of an INNER JOIN, because I'm getting incorrect records, but how can I use a LEFT JOIN in this case? Is there a way to convert the
Expand|Select|Wrap|Line Numbers
- ON (t1.EMP_ID = t2.EMP_ID) AND (t1.DamLev = t2.MinDamLev);
Expand|Select|Wrap|Line Numbers
- ON table1.column = table2.column;