如果执行从T1到T2的外部联接，则可以通过在T2值中查找空值来找到前者中不在后者中的行，类似地，T2到T1的外部联接也将为您提供T2中的行。将两者结合在一起，您将收获很多……
SELECt 'Table1' AS TableName, name, lastname FROM Table1 OUTER JOIN Table2 ON Table1.name = Table2.name2 AND Table1.lastname = Table2.lastnameWHERe Table2.name2 IS NULLUNIOnSELECt 'Table2' AS TableName, name2 as name, lastname2 as lastname FROM Table2 OUTER JOIN Table1 ON Table2.name2 = Table1.name AND Table2.lastname2 = Table1.lastnameWHERe Table1.name IS NULL
那是我的头上的-我有点生锈:)
