Do more with
SELECT column_that_should_be_unique FROM recipes_new
EXCEPT
SELECT column_that_should_be_unique FROM production.recipes
;
SELECT column_that_should_be_unique
FROM recipes_new n
WHERE NOT EXISTS (
SELECT 1
FROM production.recipes o
WHERE o.column_that_should_be_unique = n.column_that_should_be_unique
)
;
Premium Content
You need an Expert Office subscription to comment.Start Free Trial