Lines Matching refs:LEFT
80 # If the -left option is present, the join is done LEFT JOIN style.
384 test_join $tn.3 "t1 LEFT JOIN t2 ON (t1.a=t2.a)" {t1 t2 -left -on {te_equals a a}}
385 test_join $tn.4 "t1 LEFT JOIN t2 USING (a)" {
403 test_join $tn.10 "t1 NATURAL LEFT JOIN t2" {
406 test_join $tn.11 "t1 NATURAL LEFT OUTER JOIN t2" {
421 test_join $tn.16 "t2 NATURAL LEFT JOIN t1" {
424 test_join $tn.17 "t2 NATURAL LEFT OUTER JOIN t1" {
427 test_join $tn.18 "t1 LEFT JOIN t2 USING (b)" {
440 test_join $tn.23 "t1 NATURAL LEFT JOIN t3" {
443 test_join $tn.24 "t3 NATURAL LEFT JOIN t1" {
446 test_join $tn.25 "t1 LEFT JOIN t3 ON (t3.b=t1.b)" {
449 test_join $tn.26 "t1 LEFT JOIN t3 ON (t1.b=t3.b)" {
470 te_read_sql db "SELECT * FROM t3 NATURAL LEFT JOIN t2 NATURAL JOIN t1"
476 te_read_sql db "SELECT * FROM (t3 NATURAL LEFT JOIN t2) NATURAL JOIN t1"
482 te_read_sql db "SELECT * FROM (t3 NATURAL LEFT JOIN t2) NATURAL JOIN t1"
484 te_read_sql db "SELECT * FROM t3 NATURAL LEFT JOIN (t2 NATURAL JOIN t1)"
492 te_read_sql db "SELECT * FROM t3 NATURAL LEFT JOIN (t2 NATURAL JOIN t1)"
535 7 "SELECT * FROM t1, t2" "SELECT * FROM t3 NATURAL LEFT JOIN %ss%"