I have three tables in access that I have to join by SildTo column.
The first table cast, contains all soldto data, and other might or might not.
I need to create a query to show all information from cast and the other two tables even if the soldto not in some tables.
where cast.soldto(+) = table1.soldto
and cast.soldto(+) = table2.soldto