Eng 6113 left outer join wrong answer

The hack changes seem working, it looks good on the sql coverage tests. Frustrated by the wrong answer bug from Hsql.