Query data from 3 tables with similar data

[jim.kong]

Hello and thanks in advance for any responses

I have 3 excel spreadsheets that I have imported into 3 separate tables in a access db.

1. BESExport
table contains name, email, phone
2. BESSupportPagers
table contains name, email, phone, cost centre
3. CostCenters
table contains name, email, phone, cost centre

I am trying to figure out a query to match the names in (1) BESExport to the cost centers in BESSUpportPagers and CostCenters with out having to combine them all into one table.

I am pretty new to this, so sorry if this is a repetitive question.

Thanks

Jim