Hello
It is really a time consuming when we want to compare just 1 table between 2 schemas, and these tables are too large and we want to figure out the differences in a subset of data only, as we know in advance where the differences could be.
By applying WHERE clause to filter the dataset we want to compare between the 2 tables:
- adding WHERE1 to filter the table in schema1
- adding WHERE2 to filter the table in schema2
It would be a nice addition too if we have an option (yes/no) if we select more than 1 table and we want to apply the same WHERE (WHERE1 and WHERE2) to all selected tables, because sometimes we have many tables that share the same column names and the same WHERE clause is applied to all of them.
To make this easy to write the where clause, use alias for the table in schema1 as T1 (or t1), and the alias for the table in schema2 as T2 (or t2), this applies to every selected table (if we have selected more than 1 table).
Thank you.
It is really a time consuming when we want to compare just 1 table between 2 schemas, and these tables are too large and we want to figure out the differences in a subset of data only, as we know in advance where the differences could be.
By applying WHERE clause to filter the dataset we want to compare between the 2 tables:
- adding WHERE1 to filter the table in schema1
- adding WHERE2 to filter the table in schema2
It would be a nice addition too if we have an option (yes/no) if we select more than 1 table and we want to apply the same WHERE (WHERE1 and WHERE2) to all selected tables, because sometimes we have many tables that share the same column names and the same WHERE clause is applied to all of them.
To make this easy to write the where clause, use alias for the table in schema1 as T1 (or t1), and the alias for the table in schema2 as T2 (or t2), this applies to every selected table (if we have selected more than 1 table).
Thank you.
