[sqlite] Inner selects

[Bob Arnott]

Hello, I've got a query about how to get round a limitation of SQLite
(version 2.8.6) and inner selects. It's my understanding from what I've
read on the website and what I've tried on the command line that I can't
do:

SELECT *
  FROM TABLE_1, (SELECT COUNT(1)
                   FROM TABLE_2
                  WHERE TABLE_2.FK_ID=TABLE_1.ID)
 WHERE EFK_OWNER='boba';

As I can't reference the outer select from the inner one. Is there
another way of getting a count of things from another table and
appending it to a general select...?

Thanks,

--
Bob Arnott