Lines Matching refs:LEFT
33 SELECT *, '|' FROM t1 LEFT JOIN t2 ON a=234 AND x=555;
39 SELECT *, '|' FROM t1 LEFT JOIN t2 ON x=555 WHERE a=234;
45 SELECT *, '|' FROM t1 LEFT JOIN t2 WHERE a=234 AND x=555;
75 LEFT JOIN A ON (A.Name = Items.ItemName and Items.ItemName = 'dummy')
76 LEFT JOIN B ON (B.Name = Items.ItemName)
84 LEFT JOIN B ON (B.Name = Items.ItemName)
93 LEFT JOIN A ON (A.Name = Items.ItemName and Items.ItemName = 'dummy')
94 LEFT JOIN B ON (B.Name = Items.ItemName)
102 LEFT JOIN B ON (B.Name = Items.ItemName)
115 {LEFT JOIN}
123 {LEFT JOIN}
147 {LEFT JOIN}
155 {LEFT JOIN}