Lines Matching refs:q1

582 # set q1 ""
583 # append q1 "SELECT *\n"
584 # append q1 "  FROM t1 $j1 JOIN t2 ON true\n"
585 # append q1 "          $j2 JOIN t3 ON t2.y IS NOT NULL\n"
586 # append q1 "          $j3 JOIN t4 ON true\n"
587 # append q1 " ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);"
590 # echo "\\qecho X  " $q1
592 # puts $q1
596 # set q1 ""
597 # append q1 "SELECT *\n"
598 # append q1 "  FROM t1 $j1 JOIN t2 ON true\n"
599 # append q1 "          $j2 JOIN t3 ON t2.y IS NOT NULL\n"
600 # append q1 "          $j3 JOIN t4 ON true\n"
601 # append q1 " WHERE (t3.z!=400 AND t3.z!=500 AND t3.z!=600)\n"
602 # append q1 " ORDER BY coalesce(t1.x,t2.y,t3.z,t4.w,0);"
605 # echo "\\qecho X  " $q1
607 # puts $q1