Small. Fast. Reliable.
Choose any three.
*** 94,97 ****
--- 94,99 ----
  *: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. 
  
+ *:More than one primary key per table, I can specify this with MySQL for example and SQLite returns me an error: more than one primary key specified...
+ 
  (Hey, the formatting of this page was screwed up, let's see if it's better now...)