This pulls all inactive records in untype and the matching records in incilog as it should:

lcSelect = "SELECT " ;
+" * " ;
+" FROM Table1 a LEFT OUTER JOIN Table2 b on LTRIM(RTRIM(a.unitcode)) = LTRIM(RTRIM(b.unitcode))" ;
+" AND LTRIM(RTRIM(a.unittype)) = LTRIM(RTRIM(b.usertyped))" ;
+" WHERE a.inactive = 'TRUE' and EXISTS ( SELECT * FROM untype WHERE inactive = 'TRUE' ) ";
+" ORDER BY a.unitcode, a.unittype, b.timestamp DESC "

However, my goal now is to pull all records in Table1 that have inactive = 'true' (whether or not there is a matching record in Tabl2) but only pull the top 5 matching records in Table2 by timestamp descending (the 5 most recent records in Table2) for each record pulled in Table1 (if any matching records exist in Table2). I am stumped this morning, ideas?