Lines Matching refs:id

73   CREATE TABLE A(id INTEGER PRIMARY KEY, label TEXT);
74   CREATE TABLE B(id INTEGER PRIMARY KEY, label TEXT, Aid INTEGER);
76     id INTEGER PRIMARY KEY,
83   INSERT INTO A(id) VALUES(1);
84   INSERT INTO B(id) VALUES(2);
85   INSERT INTO C(id,xx,yy,zz) VALUES(99,50,1,2);
88          (SELECT id,xx,yy,zz FROM C) subq,
90    WHERE A.id='1'
91      AND A.id=subq.yy
92      AND B.id=subq.zz;
97          (SELECT id,xx,yy,zz FROM C) subq,
99    WHERE A.id=1
100      AND A.id=subq.yy
101      AND B.id=subq.zz;
106          (SELECT id,yy,zz FROM C) subq,
108    WHERE A.id='1'
109      AND A.id=subq.yy
110      AND B.id=subq.zz;