problem with two table update query

[sneakyimp]

I'm getting an error when I run this query:

UPDATE
  raw_mli_revision
  raw_mli_sfr

SET
  raw_mli_revision.ocb = raw_mli_sfr.occupiedby,
  raw_mli_revision.ocp = raw_mli_sfr.ocpntphone

WHERE
  raw_mli_revision.listing_id = raw_mli_sfr.listing_id
  AND
  raw_mli_revision.source = 'raw_mli_sfr' 

MySQL says:

#1054 - Unknown column 'raw_mli_revision.listing_id' in 'where clause' 

I'm trying to update two fields in the first table with matching data from the second table. I've read the MySQL docs and this looks like valid syntax to me. The field is definitely there in the table definition.

Can anyone recommend a query to accomplish this?

[sneakyimp]

Nevermind...this appears to be working for me:

UPDATE
    raw_mli_revision r
    INNER JOIN raw_mli_sfr s
    ON (s.listing_id=r.listing_id AND r.raw_source='raw_mli_sfr')

   SET
    r.ocb = s.occupiedby,

r.ocp = s.ocpntphone