On Thu, 15 Sep 2016 15:53:10 +0000 (UTC) David Bicking <dbic...@yahoo.com> wrote:
> (1) The CombinedKeyFields must always match in each table(2) Match > using the EvtNbr, but if no match, use the lowest M.EvtNbr that > matches the CombinedKeyFields > > (3) Match using the TransDate but if no exact match, match on the > M.TransDate that is less than the E.TransDate but greater than the > prior E.TransDate I think this is what you describe: select E.CombinedKeyFields, max(M.EvtNbr) as EvtNbr, max(M.TransDate) as TransDate from E left join M on E.CombinedKeyFields = M.CombinedKeyFields and E.EvtNbr >= M.EvtNbr and E.TransDate >= M.TransDate --jkl _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users