What's the most concise way in sql to select from 5 different tables..

[Supplement]

I want some data from each.. but mainly the telephone numbers found in each of these tables..

The ultimate goal is to create a type of phone book, so when someone searches in the phone number input box it returns all the phones numbers that match from those five different categories (tables).....

any help would be greatly appreciated.

Here's what i have now...

select 

code,
first,
last,
phoneday,
phonenight,
dfcode

from event.dbo.patient_dg()

select 

id,
doctor_id,
phone,
fax

from event.dbo.doctor_alt_address

select 

CODE_,
NAME_,
PHONE,
FAX

from ARE.APS.RFDME

select 

CODE_,
FIRST_,
LAST_,
PHONE,
FAX

from ARE.APS.DFDME

Select *

from pharmacy.dbo.chain

Select *

from crm.dbo.rf_contacts