I wanted to create a stored procedure that is a select statement from multiple tables into 1 result set. I also what to pass the stored procedures a bunch of parameters that will be part of the select statement.

for ex: parameter1={01/01/2005}
parameter2={12/31/2005}

stored procedure

select * from table1,table2,table3 where table1.field1 between(parameter1,parameter2) and table2.field1 between(parameter1,parameter2) and table3.field1 between(parameter1,parameter2)

endprocedure