Can someone please tell me what is wrong with this query.

UPDATE VT_TR_TABLE
SET VT_TR_TABLE.DISTRI = VT_TR_CABLE_TABLE.CA FROM VT_TR_TABLE INNER
JOIN VT_TR_CABLE_TABLE ON
VT_TR_TABLE.MASTER_KEY = VT_TR_CABLE_TABLE.MASTER_KEY;

When I try to run it it gives the following error.

Token unknown FROM

The query is supposed to update DISTRI to CA where the two master
keys match.

Thanks for your help
Lin