# Test updates with joins
---
- CreateTable: t1 (id SERIAL PRIMARY KEY, other_id INT)
---
- Statement: INSERT INTO t1 (other_id) VALUES (1), (2), (3), (4), (5), (6)
---
- Statement: UPDATE t1 SET other_id = NULL WHERE id in (1, 2)
---
- Statement: SELECT * FROM t1 ORDER BY id
- output: [[1,null],[2,null],[3,3],[4,4],[5,5],[6,6]]
...


Add an IT of the overall effect.
Add an IT of the overall effect.
