What type of database are you connecting to?
There really is no direct relationship between the two types of link options. For the XI join types, you need to look at it based on the fact that you're linking "From" one table "To" another. In database terms, the "From" table is on the left and the "To" table is on the right. Based on that, here's the definitions:
Inner join - only include the data that matches in both tables based on the field in the link.
Left outer join - include all of the records in the left (from) table even if they don't match any records in the right (to) table.
Right outer join - include all of the records in the right (to) table even if they don't match any records in the left (from) table.
Full join - include all records from both tables.
I've been working with XI since shortly after it came out - I've NEVER had to use the Apply join options - I leave them at the default.
-Dell
IP Logged
