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