Thread: SQL Statement Help!!

I know that this probably not the correct place to post my question but the
following statement is not executing. What am I doing wrong?

UPDATE children SET children_schoolid = ( select school_id = school )
WHERE otherschool in ( select school_name from school ) and otherschool is
not null;

Thank-you for your time.

Jacob