table select

SELECT table_name,
COUNT(DISTINCT db) AS db_count,
-- STRING_AGG(db, ', ') AS databases -- uncomment if ASE 16+ supports it
FROM (
SELECT 'db1' AS db, name AS table_name FROM db1..sysobjects WHERE type = 'U'
UNION ALL
SELECT 'db2', name FROM db2..sysobjects WHERE type = 'U'
UNION ALL
SELECT 'db3', name FROM db3..sysobjects WHERE type = 'U'
UNION ALL
SELECT 'db4', name FROM db4..sysobjects WHERE type = 'U'
) AS all_tables
GROUP BY table_name
ORDER BY db_count DESC, table_name;