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