how can i
bind two tbls (returning by 2 select queries)
or
retrieve all these data(columns) in single tbl,
i mean that retrieve all these data in single tbl containing 5 coumns instead of 4 (with pname of 2nd select query)
create proc [dbo].[SpCateProducts](@cate_id int)
as
begin
select sb.subcate_name, sum(p.qty)
from subcategory sb
join product p on p.subcate_id = sb.subcate_id
where sb.cate_id = @cate_id
group by sb.subcate_name
select top 1 pname from product join subcategory
on product.subcate_id=
(
select top 1 subcate_id
from subcategory
where cate_id=3
order by NEWID()
)
end