[firebase-br] UPATE + INNER JOIN

[Brayan Cicarone]

Amigo tente desta forma e vê se resolve :

UPDATE TB_C100 SET
 COD_SIT = '08'
WHERE TB_C170.ID_C100 in (SELECT TB_C100.ID <http://tb_c100.id/>
                                              from TB_C170
                                              WHERE TB_C170.CFOP = '5929' OR
TB_C170.CFOP = '6929'


Espero ter ajudado  ^ ^

qualquer duvida no update q te passei estamos ai!