Home
last modified time | relevance | path

Searched refs:tab2 (Results 1 – 3 of 3) sorted by relevance

/sqlite-3.40.0/test/
H A Dtkt2141.test31 CREATE TABLE tab2 (t2_id integer PRIMARY KEY, t2_id_t1, t2_desc);
32 INSERT INTO tab2 VALUES(1,1,'rec 1 tab 2');
36 FROM tab1 t1 LEFT JOIN tab2 t2 ON t1.t1_id = t2.t2_id_t1
38 (SELECT t2_id FROM tab2, tab3 ON t2_id = t3_id_t2
45 FROM tab1 t1 LEFT JOIN tab2 t2 ON t1.t1_id = t2.t2_id_t1
47 (SELECT t2_id FROM tab2, tab3 ON t2_id = t3_id_t2
54 FROM tab1 t1 LEFT JOIN tab2 t2
56 (SELECT t2_id FROM tab2, tab3 ON t2_id = t3_id_t2
H A Dtkt3522.test38 CREATE TABLE tab2(col0 INTEGER);
39 SELECT cor0.* FROM tab1 NATURAL JOIN tab2 AS cor0;
/sqlite-3.40.0/src/
H A Dselect.c3008 int tab1, tab2; in multiSelect() local
3020 tab2 = pParse->nTab++; in multiSelect()
3040 addr = sqlite3VdbeAddOp2(v, OP_OpenEphemeral, tab2, 0); in multiSelect()
3046 intersectdest.iSDParm = tab2; in multiSelect()
3071 sqlite3VdbeAddOp4Int(v, OP_NotFound, tab2, iCont, r1, 0); in multiSelect()
3079 sqlite3VdbeAddOp2(v, OP_Close, tab2, 0); in multiSelect()