By default QlikView join tables with the same name. If there are a lot of filds with the same name you will have problem with joining tables without getting circular references.
One option to solve this is to rename fields with the same name, e.g. LOAD Customer as _______. But with a lot of fields that would be tiresome.
Try to use Qualify *; before the first LOAD statement - that will give you a datamodel in QlikView with naming like table.fieldname. (e.g. Customer.CustomerName). Then use Unqualify fieldname, fieldname...; to keep the name on the fields you want to join.
Hop this will help you get started.
Torbjörn Ungavll (@Ungvall)
Senior Business Discovery Manager @ Advectas AB