CREATE PROCEDURE dbo.get_cars_and_cities1 AS BEGIN -- Return rows from 'cars' table SELECT * FROM Test_Practice.dbo.emp;

-- Return rows from 'cities' table
SELECT * FROM Test_Practice.dbo.emp2;

END;

EXEC dbo.get_cars_and_cities1;

I want to achive the same behaviour in pSql, Anyone can suggest me how should i display the 2 result set in one function or query.