major revisions. left and inner join now work better, millions of bugs. runs test data successfully except for 0475 and a couple of unimportant character encoding errors