SQL in Access 2013 -

SQL in Access 2013 -

i have 2 tables in ms access 2013 database have pulled through odbc. 1 called public_phone_numbers , 2nd public_customer. need bring together 2 fields phone_acct , phone_number phone table client table. phone business relationship number same client business relationship number, need each business relationship have phone number listed on customer's table well.

here thought work:

select public_phone_numbers.phone_acct, public_phone_numbers.phone_number public_phone_numbers inner bring together public_customer on public_phone_numbers.phone_acct = public_customer.c_acct;

not sure understand need, perhaps it's left outer join?

select c.*, p.phone_number public_customer c left outer bring together public_phone_numbers p on c.c_acct = p.phone_acct

sql ms-access-2013