Lines Matching refs:id

25   CREATE TABLE customer (id INT PRIMARY KEY);
26   CREATE TABLE apr (id INT PRIMARY KEY, apr REAL);
29   SELECT c.id, i.apr
31   LEFT JOIN apr i ON i.id=c.id;
34   SELECT c.id, i.apr
36   RIGHT JOIN customer c ON i.id=c.id;
39   SELECT c.id, v1.apr
41   LEFT JOIN v1 ON v1.id=c.id;
44   SELECT c.id, v1.apr
45   FROM v1 RIGHT JOIN customer c ON v1.id=c.id;
48   SELECT c.id, v1rj.apr
49   FROM v1rj RIGHT JOIN customer c ON v1rj.id=c.id;
51   INSERT INTO customer (id) VALUES (1);
52   INSERT INTO apr (id, apr) VALUES (1, 12);
53   INSERT INTO customer (id) VALUES (2);
54   INSERT INTO apr (id, apr) VALUES (2, 12.01);
58   SELECT id, (apr / 100), typeof(apr) apr_type  FROM v1;
62   SELECT id, (apr / 100), typeof(apr) apr_type  FROM v1rj;
65   SELECT id, (apr / 100), typeof(apr) apr_type  FROM v2;
68   SELECT id, (apr / 100), typeof(apr) apr_type  FROM v2rj;
71   SELECT id, (apr / 100), typeof(apr) apr_type  FROM v2rjrj;
75   SELECT id, (apr / 100), typeof(apr) apr_type  FROM v1;
78   SELECT id, (apr / 100), typeof(apr) apr_type  FROM v1rj;
81   SELECT id, (apr / 100), typeof(apr) apr_type  FROM v2;
84   SELECT id, (apr / 100), typeof(apr) apr_type  FROM v2rj;
87   SELECT id, (apr / 100), typeof(apr) apr_type  FROM v2rjrj;
94   CREATE TABLE map_integer (id INT, name);
96   CREATE TABLE map_text (id TEXT, name);
98   CREATE TABLE data (id TEXT, name);
109   #SELECT * FROM data JOIN idmap USING(id);
112   SELECT * FROM data JOIN mzed USING(id);
117   SELECT * FROM data JOIN idmap USING(id);
120   SELECT * FROM data JOIN mzed USING(id);