By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| search_id_1 | search_id_2 | foo_id_1 | foo_id_2 | foo_name |
|---|---|---|---|---|
| 1a | 1b | 1a | 1b | A |
| 2a | 2b | 2a | 2b | CCC |
| 3a | 3b | 3a | 3b | EEEEE |
Warning: Null value is eliminated by an aggregate or other SET operation.