“They are not available in the UI but very easy to…” — Learn Microsoft Excel with MyExcelOnline at 35:16
“They are not available in the UI but very easy to implement just by modifying the join kind parameter in the formula bar. These join types are most efficient when your data source supports query folding, pushing the heavy lifting back to the source system for faster performance. Let's get a brief description for each…”
0:00
39:37