Lines Matching refs:j2
34842 # foreach j2 {INNER LEFT RIGHT FULL} {
34849 # append q1 " $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34864 # append q1 " $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34879 # append q1 " $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34894 # append q1 " $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34909 # append q1 " $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34924 # append q1 " $j2 JOIN t3 ON t1.c=t3.c\n"
34939 # append q1 " $j2 JOIN t3 ON t1.c=t3.c\n"
34954 # append q1 " $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34969 # append q1 " $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34984 # append q1 " $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34999 # append q1 " $j2 JOIN t3 ON t1.c=t3.c\n"
35014 # append q1 " $j2 JOIN t3 ON t1.c=t3.c\n"
35029 # append q1 " $j2 JOIN t3 ON t1.c=t3.c\n"
35041 # set op2 [expr {$j2=="FULL"?"=":"IS NOT DISTINCT FROM"}]
35047 # append q1 " $j2 JOIN t3 ON t1.c $op2 t3.c AND t3.y>0\n"
35061 # append q1 " $j2 JOIN t3 ON t1.c $op2 t3.c AND t3.y>0\n"
35076 # append q1 " $j2 JOIN t3 ON t3.y>0\n"
35091 # append q1 " $j2 JOIN t3 ON t1.c $op2 t3.c AND t3.y>0\n"
35107 # append q1 " $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
35118 # if {$j2!="FULL"} {
35123 # append q1 " $j2 JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0\n"