在SQL中查询多个不相关的表

I have more than 50 tables that are not related but all of them have a "Name" field, I want to query "John" and get all Johns in the different tables and store each row in an array (Javascript) for example:I have more than 50 tables that are not related