Stored procedure

Question

I want to create a stored procedure where the procedure will select only selected columns from tables and merge into single output how can i do it? Please give some example...Thanks