Lines Matching refs:foo

371   CREATE TABLE foo (Id INTEGER PRIMARY KEY, fa INTEGER, fb INTEGER); 
374   INSERT INTO foo VALUES(1, 1, 1);
375   INSERT INTO foo VALUES(2, 1, 2);
376   INSERT INTO foo VALUES(3, 1, 3);
377   INSERT INTO foo VALUES(4, 1, 4);
378   INSERT INTO foo VALUES(5, 1, 5);
379   INSERT INTO foo VALUES(6, 1, 6);
380   INSERT INTO foo VALUES(7, 1, 7);
381   INSERT INTO foo VALUES(8, 1, 8);
382   INSERT INTO foo VALUES(9, 1, 9);
397     bar.Id, bar.ba, bar.bb, foo.fb
398     FROM foo LEFT JOIN bar
399            ON (bar.ba = 1 AND bar.bb = foo.fb)
400            OR (bar.ba = 5 AND bar.bb = foo.fb);
416     bar.Id, bar.ba, bar.bb, foo.fb
417     FROM foo LEFT JOIN bar
418            ON (bar.ba = 1 AND bar.bb = foo.fb)
419            OR (bar.ba = 5 AND bar.bb = foo.fb);