如何update一個table，但是根據另一個table的資料來決定...
===============================================================
UPDATE orders a
SET a.order_sales = 'test'
WHERE EXISTS (SELECT b.order_no
FROM order_lst b
WHERE a.order_no = b.order_no AND b.lst_status = 'CX')
AND a.order_no BETWEEN 'SPO0000122840' AND 'SPO0000123023'
AND a.order_sales IS NOT NULL
0 意見:
張貼留言