UPDATE table1 SET val='X'

X= SELECT COUNT(page) AS X FROM table2 WHERE order_no=1

UPDATE table1
SET val = (
           SELECT COUNT(page)
           FROM table2
           WHERE order_no = 1
          )