none
USQL Joins with Or Conditions

    Question

  • It appears that OR conditions are not supported in U-SQL Joins.  Is this accurate?  Is there a reason for this?  I have a self join that I need to ensure rows with Null values are kept but I can't add a condition for it in the ON statement of a join.  I've had to either do a CROSS JOIN and move the condition to a WHERE clause or I've had to do an INNER JOIN with a wider selection criteria and then moved some of the conditions to the WHERE statement.
    Tuesday, April 24, 2018 1:50 PM

All replies