sql - How to create a stored procedure which pulls data from multiple tables that are not linked What do i do -

I need to create a stored procedure that pulls data from several tables, which is not what I am doing. I basically have a few tables which are not linked and all I need to do is pull all data from all the tables.

Please my life depends on it

Just select several?

  Choose * from MyTable1; Choose * from MyTable2; Choose * from MyTable3;  

You can then access each table with your calling code. I have included an example on how to do this, but there are no details about what you are calling from I would have included the details if my life was dependent on it :)

If you mean that you have rows in several tables, and you want to pull them all back, You can do this by doing so.