1 files changed, 15 insertions, 0 deletions
diff --git a/doc/TODO b/doc/TODO
index d7dd75d62e..0f688bc258 100644
--- a/doc/TODO
+++ b/doc/TODO
@@ -1,4 +1,19 @@
 todo:
+- joining with LIMIT is like aggregations!!
+
+users.delete().where( 
+    addresses.c.user_id== 
+         select([users.c.id]). 
+         where(users.c.name=='jack') 
+    ) 
+
+    SELECT id, name, 
+      (select count(*) FROM addresses WHERE 
+    user_id=users.id) 
+    FROM users 
+
+    SELECT users.*, (SELECT count(id) FROM addresses WHERE 
+    addresses.user_id=users.id) FROM users
 - and/or w/ predicates
 - blocks for all operations
 - result sets to attr correlation too