[firebase-br] UPATE + INNER JOIN

[Diego Maccari]

Boa Tarde pessoal, preciso fazer um update em uma tabela Chamada TB_C100 na coluna COD_SIT,  mas preciso unir estes registro com um INNER JOIN em uma tabela chamada TB_C170
tentei assim, mas da erro. Invalid token. Dynamic SQL Error. SQL error code = -104. Token unknown - line 6, column 1.  SELECT.

Alguém poderia me ajudar a entender o erro.


UPDATE TB_C100 SET
  COD_SIT = '08'
WHERE
SELECT TB_C100.ID, TB_C100.ID_C010, TB_C100.REG, TB_C100.IND_OPER, TB_C100.IND_EMIT, TB_C100.COD_PART, TB_C100.COD_MOD,
  TB_C100.COD_SIT, TB_C100.SER, TB_C100.NUM_DOC, TB_C100.CHV_NFE, TB_C100.DT_DOC, TB_C100.DT_E_S, TB_C100.VL_DOC,
  TB_C100.IND_PGTO, TB_C100.VL_DESC, TB_C100.VL_ABAT_NT, TB_C100.VL_MERC, TB_C100.IND_FRT, TB_C100.VL_FRT, TB_C100.VL_SEG,
  TB_C100.VL_OUT_DA, TB_C100.VL_BC_ICMS, TB_C100.VL_ICMS, TB_C100.VL_BC_ICMS_ST, TB_C100.VL_ICMS_ST, TB_C100.VL_IPI,
  TB_C100.VL_PIS, TB_C100.VL_COFINS, TB_C100.VL_PIS_ST, TB_C100.VL_COFINS_ST, TB_C170.ID_C100, TB_C170.CFOP
  FROM TB_C170
  INNER JOIN TB_C100 ON (TB_C170.ID_C100 = TB_C100.ID)
    WHERE TB_C170.CFOP = '5929' OR TB_C170.CFOP = '6929'