Tag: postgresql

General

Comparing two columns across tables for a remaining subset

How can I find the unique phone numbers (and collapse them into a single column) from table_1 (while keeping the IDs and date fields), and remove phone numbers that appear in table_2? table_1 ID phone1 phone2 date 1 1111111111 2021-12-31 5 2222222222 3333333333 2020-11-08 8 5555555555 2021-03-15 14 7777777777 8888888888 2016-10-20 table_2 ID phone1 phone2 […]

Continue Reading