*** 91,94 ****
--- 91,97 ----
*:AUTO_INCREMENT field type. SQLite supports auto_incrementing fields but only if that field is set as "INTEGER PRIMARY KEY".
+ *:SELECT t1.ID, (SELECT COUNT(*) FROM t2 WHERE t2.ID=t1.ID) FROM t1{linebreak}
+ _:In other words, in a subselect backreferencing to a field in its parent select.
+
(Hey, the formatting of this page was screwed up, let's see if it's better now...)
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|