Hey guys, When I run the following query: SELECT foo, bar FROM table1 WHERE fk_id = 637 AND utc > '2022-10-16' UNION SELECT foo, bar FROM table2 WHERE fk_id = 637 AND utc > '2022-10-16'
I'm getting only one row per table. If I add the column "utc" to the list in SELECT, I get the expected result.