im hoping someone can help me create a table that will allow me to join two tables that have and display the records for all unique records.

i have two tables, each table contains a customer record number and balance.

not all tables contain same records, im hoping to build a query that will all me to pull in all unique records and the balance from each table.

for example:

table one

customer balance
jones 5
smith 6
johnson 7
michaels 8



table two

customer balance
jones 5
smith 6
johnson 7
stevens 9

the result of the query will be

customer balance from table1 balance from table 2
jones 5 5
smith 6 6
johnson 7 7
michaels 8 null
stevens null 9