What is the difference between an association between logical tables, a load or select statement preceded by a join qualifier, and a join within a select statement?
An association is a join between logical tables which is evaluated when you click on a field value in your application. QlikView makes this association automatically when two different tables have a field in common. The two latter joins are made during script execution and result in new logical tables. In these cases, QlikView does not load the original tables as logical tables. Furthermore, a join within a select statement will usually only load those records whose key field value is found in both tables (inner join), whereas the two former joins also include records whose key field value is found in only one of the tables (full outer join).
