In SQL Server, I can write a stored procedure that looks something like this:
CREATE PROCEDURE MyProc AS DECLARE @someVariable INT SELECT @someVariable = someColumn FROM someTable WHERE someConditionThatReturnsOneRow SELECT someOtherColumn FROM someOtherTable WHERE thePrimaryKey = @someVariable END PROCEDURE Other features available in SQL Server stored procedures include while loops, temporary tables, and the FETCH command to retrieve data from a resultset one row at a time. I have SQLite Explorer and SQLiteSpy. Does either one have similar capabilities? Thanks very much! Rob Richardson RAD-CON, Incv.