:left-join

Like join but returns rows even if there are no matches in the right relation.

Like SQL LEFT JOIN.

Form

left-join = [:left-join right clause & more]
right = query | table
clause = {left-expr right-expr, ...}

Examples

[[:from :Customer]
 ;; if orders are missing, you will get customer rows on their own
 [:left-join :Order {:id :customer-id}]]