how to combine multiple select statements in stored proc

Question

how to combine multiple select statements in stored proc

 

like:

 

create procedure [somename] 

{

select A.id.A.number from a where A.id=102

select B.id from B where  where B.id=111

 

} 

 

 

how do i get single result set?