I would like to the top most record from Xtraction based on a join. Table A drives the query while it relies on data from Table B. For each record in Table A, there could be multiple records in Table B that coincide with Table A. So in Table B, I created a field using the following SQL statement: (SELECT top 1 act_log.CALL_REQ_ID FROM act_log INNER JOIN act_type ON act_log.type = act_type.code INNER JOIN call_req ON act_log.call_req_id = call_req.persid WHERE (call_req.persid = 'ACTIVITY_LAST_LOG_COMMENT.CALL_REQ_ID') and act_log.type='LOG' order by time_stamp desc). There are other fields that I have made available in TABLE B. When I leverage one of the those, the value is blank even though I should data. Can anyone help me with this?