Yes- create stored procedure and write select statement separated by ;

Yes, We can retrieve data from more than 1 table using different select statement in Store Procedure

create procedure multiple as begin select * from customer,users end end

create procedure multiple as begin select * from customer,users end end