SELECT column_name, max( CASE WHEN table_name = 'table1' AND table_schema = 'db1' THEN 'Yes' END ) AS in_table_1, max( CASE WHEN table_name = 'table1' AND table_schema = 'db2' THEN 'Yes' END ) AS in_table_2 FROM information_schema. COLUMNS WHERE ( ( table_schema = 'db1' AND table_name = 'table1' ) OR ( table_schema = 'db2' AND table_name = 'table1' ) ) AND table_name IN ('table1', 'table1') GROUP BY column_name ORDER BY column_name;