I am trying to understand Inner Joins in QlikView so can someone please translate the below simple sql script to QlikView load and select code? Here attendee is a table with alias a and timespend is a table with alias b trying to join the two tables with common customerid field. Thanks.
The Join and Keep prefixes can be preceded by the prefix inner.
If used before join it specifies that an inner join should be used. The resulting table will thus only contain combinations of field values from the raw data tables where the linking field values are represented in both tables.
If used before keep, it specifies that both raw data tables should be reduced to their common intersection before being stored in QlikView.