The whole point is that QlikView does an automatic inner join on all fields with the same name. What you want is an outer join between some of the tables. If at all possible in Qlikview the way you want it, you should consider different fieldnames between tables and only join those of vital importance. Otherwise you should construct the query using outer joins in your source database.
I found the solution in another thread that was posted minutes after I made myn which has the solution that I needed and I needed to uncheck the 'Suppress Zero values' in the presentation tab.
Thanks for the reply though.
Left join returns all rows from the first table, and only matching rows from the second table.
Right join returns all values from the second table, and only matching values from the first table.
Outer join returns all rows from the first table and all rows from the second table.
In your case use outer join.
try this code in script
OUTER JOIN (Models) LOAD * RESIDENT Orders;