Stairway to U-SQL Level 8: Joining Tables in U-SQL


 * http://www.sqlservercentral.com/articles/U-SQL/145032/

U-SQL comes from the data lake ability of U-SQL to dive into the data

Join Types U-SQL supports a number of join types – some may well be familiar to you, others may not.


 * INNER JOIN -|- JOIN
 * FULL OUTER JOIN
 * LEFT OUTER JOIN
 * RIGHT OUTER JOIN
 * CROSS JOIN
 * LEFT SEMIJOIN
 * RIGHT SEMIJOIN
 * LEFT ANTISEMIJOIN
 * RIGHT ANTISEMIJOIN