sql - 如何发现两个值列之间的差异？

Question

我在 postgreSQL 中使用 except 语法来检查两个表中的地址是否匹配，下面是不匹配的值。

select Address from allsalesdata
except
select Address from addresses

我已复制缺失的地址并粘贴到 Excel 中以检查数据源(地址)，但我无法发现差异。我已经检查了 Excel 中的 if 和 exact 公式，以检查这两个值是否匹配并且答案是否定的。如何在 SQL 中找出两个列值之间的差异？

    allsalesdata                         addresses

111 Thoroughbred Avenue         111 Thoroughbred Avenue 
222 Bannerdale Blvd             222 Bannerdale Blvd 
3333 Stampede Drive             3333 Stampede Drive 
444 Stampede Drive              444 Stampede Drive 
555 Thoroughbred Avenue         555 Thoroughbred Avenue 

Answer 1

尝试使用 trim

trim([leading | trailing | both] [characters] from string)

Remove the longest string containing only the characters (a space by default) from the start/end/both ends of the string

select trim(both ' ' from Address) as Address from allsalesdata
except
select trim(both ' ' from Address) as Address from addresses