"MoDementia" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > One thing that I really miss form another database is the ability to > reuse select statements. > > Select * FROM Transactions Where DateTime Between x and y Saving > Unique DataID to 1
How about create temp view view1 as Select distinct DataID FROM Transactions Where DateTime Between x and y; > GetList 1 I'm not sure what that's supposed to do, but perhaps select * from view1; > Select * From Data Using 1 It's not clear what that's supposed to do either, but perhaps select * from Data where ID in (select DataID from view1); Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users