searching multiple Tables

im in need of some help, im new at sql and am trying to seach multiple tables.

i am doing a football database with a table for each of the teams
and each table has the following
"First Name" "Last Name" "Age" "Date of Birth" etc

what i am trying to do is search for either the "first name" or "last name" in every table

if anyone can help me it would be apreciated

That's your problem. Use one table for all teams.