inner join in mysql update with last record

0

I have the following table, when doing inee join this take (or place) the first result that it finds and I want it to take the last, is there a way to force or modify my query? (when supertoken_id is dated 06/02/2018 and id = 1116741)

     UPDATE supertoken INNER JOIN _tablasupertoken
    ON supertoken.supertoken_id =_tablasupertoken.supertoken_id
SET supertoken.sucursal=_tablasupertoken.sucursal;
    
asked by sanlegas 09.05.2018 в 21:01
source

0 answers