您可以比较每个表中的数据，并仅返回不匹配的行：

SELECT * FROM table1 FULL OUTER JOIN table2 ON table1.column1 =table2.column1
    AND table1.column2 = table2.column2 AND table1.column3 = table2.column3
    WHERE table1.column1 IS NULL OR table2.column1 IS NULL;

您可以修改此查询以在联接条件中包括其他列，具体取决于表中的列数。
然后，您可以使用EXCEPT运算符来比较每个表中的数据。首先选择表1中不在表2中的所有行，然后选择表2中不在表1中的所有行。UNION ALL运算符将这两个查询的结果组合在一起，以显示两个表中所有不同的行。
下面是如何执行此操作的示例：

SELECT * FROM table1 EXCEPT SELECT * FROM table2;
    UNION ALL
    SELECT * FROM table2 EXCEPT SELECT * FROM table1;
    This query first selects all rows from `table1` that are not in `table2`, and then selects all rows from `table2` that are not in `table1`. The `UNION ALL` operator combines the results of these two queries to show all the rows that are different between the two tables.