*** 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...)