SQLite for joined tables

Question

How would I convert the following statement from MySQL-ese to SQLite-ese?

UPDATE Attribute, Name 
  SET Attribute.AttValue = 'foobar'
  WHERE Attribute.NameID = Name.NameID 
    AND Name.Name = 'rotate_ccw'

It looks like SQLite doesn't support joins in an UPDATE statement.

Answer 1

UPDATE Attribute
  SET Attribute.AttValue = 'foobar'
  WHERE Attribute.NameID = (SELECT Name.NameID FROM Name WHERE Name.Name = 'rotate_ccw')