Lines Matching refs:j1

34841 # foreach j1 {INNER LEFT RIGHT FULL} {
34848 # append q1 "  FROM t1 $j1 JOIN t2 ON t1.b=t2.b AND t2.x>0\n"
34859 # if {$j1!="FULL"} {
34863 #   append q1 "  FROM t1 $j1 JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0\n"
34878 # append q1 "  FROM t1 $j1 JOIN t2 ON t1.b=t2.b\n"
34893 # append q1 "  FROM t1 $j1 JOIN t2 ON t1.b=t2.b\n"
34908 # append q1 "  FROM t1 $j1 JOIN t2 ON true\n"
34923 # append q1 "  FROM t1 $j1 JOIN t2 ON t1.b=t2.b AND t2.x>0\n"
34938 # append q1 "  FROM t1 $j1 JOIN t2 ON t1.b=t2.b AND t2.x>0\n"
34953 # append q1 "  FROM t1 $j1 JOIN t2 ON t1.b=t2.b AND t2.x>0\n"
34968 # append q1 "  FROM t1 $j1 JOIN t2 ON t1.b=t2.b AND t2.x>0\n"
34983 # append q1 "  FROM t1 $j1 JOIN t2 ON t1.b=t2.b\n"
34998 # append q1 "  FROM t1 $j1 JOIN t2 ON t1.b=t2.b AND t2.x>0\n"
35013 # append q1 "  FROM t1 $j1 JOIN t2 ON t1.b=t2.b\n"
35028 # append q1 "  FROM t1 $j1 JOIN t2 ON t1.b=t2.b\n"
35040 # set op1 [expr {$j1=="FULL"?"=":"IS NOT DISTINCT FROM"}]
35046 # append q1 "  FROM t1 $j1 JOIN t2 ON t1.b $op1 t2.b AND t2.x>0\n"
35060 # append q1 "  FROM t1 $j1 JOIN t2 ON t2.x>0\n"
35075 # append q1 "  FROM t1 $j1 JOIN t2 ON t2.x>0\n"
35090 # append q1 "  FROM t1 $j1 JOIN t2 ON t2.x>0\n"
35102 # if {$j1!="FULL"} {
35106 #   append q1 "  FROM t1 $j1 JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0\n"
35122 #   append q1 "  FROM t1 $j1 JOIN t2 ON t1.b=t2.b AND t2.x>0\n"