Sql:WITH tmp AS ( SELECT cardnum, MAX ( receivetime ) AS receivetime FROM uwb20230626 GROUP BY cardnum ) SELECT b.*, A.farfromroadway, A.backroadwaydirection FROM worksite A INNER JOIN uwb202...