consultar varias tablas registro multiples

[xoceunder]

ok ya solucione como poder buscar en barias tablas aqui dejo por si otro puede hacerle falta

Código SQL:

SELECT account, COUNT( * ) AS duplica
FROM (
SELECT account
FROM bd1.accounts
UNION ALL SELECT account
FROM bd2.accounts
UNION ALL SELECT account
FROM bd3.accounts
UNION ALL SELECT account
FROM bd4.accounts
) AS todo
GROUP BY account
HAVING COUNT( * ) >1
LIMIT 0 , 50