1个月前 · software

比较3

sql SELECT 'ONLY_IN_US_1' AS location, t1.table_name FROM dba_tables t1 LEFT JOIN dba_tables t2 ON t1.table_name = t2.table_name AND t2.owner = 'GL...

1个月前 · software

比较2

sql SELECT CASE WHEN t1.table_name IS NOT NULL AND t2.table_name IS NULL THEN 'ONLY_IN_US_1' WHEN t2.table_name IS NOT NULL AND...