Lines Matching refs:left
54 # of the two inputs. The [te_tbljoin] command reads the left and right-hand
62 # -left
68 # * The list of column-names from the left-hand dataset.
69 # * A single row from the left-hand dataset (one "data row" list as
80 # If the -left option is present, the join is done LEFT JOIN style.
82 # exist rows in the left-hand dataset that have no corresponding rows in
138 # ?-left?
152 -left { set isleft 1 }
350 # the left and right-hand datasets.
384 test_join $tn.3 "t1 LEFT JOIN t2 ON (t1.a=t2.a)" {t1 t2 -left -on {te_equals a a}}
386 t1 t2 -left -using a -on {te_equals a a}
404 t1 t2 -left -using {a b} -on {te_and {te_equals a a} {te_equals b b}}
407 t1 t2 -left -using {a b} -on {te_and {te_equals a a} {te_equals b b}}
422 t2 t1 -left -using {a b} -on {te_and {te_equals a a} {te_equals b b}}
425 t2 t1 -left -using {a b} -on {te_and {te_equals a a} {te_equals b b}}
428 t1 t2 -left -using b -on {te_equals b b}
441 t1 t3 -left -using b -on {te_equals b b}
444 t3 t1 -left -using b -on {te_equals -nocase b b}
447 t1 t3 -left -on {te_equals -nocase b b}
450 t1 t3 -left -on {te_equals b b}
456 # in order from left to right. In other words, the FROM clause (A
466 te_tbljoin db t3 t2 -left -using {b} -on {te_equals -nocase b b}
494 -left -using {b} -on {te_equals -nocase b b} \
536 {t3 %ss% -left -using b -on {te_equals -nocase 0 1}}