我如何绑定两个TBL(由2个选择查询返回) [英] how can i bind two tbls (returning by 2 select queries)

问题描述

我如何绑定两个tbl(通过2个选择查询返回)
或
在单个tbl中检索所有这些数据(列)，
我的意思是在单个tbl中检索所有这些数据，其中包含5个列而不是4个列(pname为2nd select查询)

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

推荐答案

没有表模式(我记得您先前的问题 [ ^ ] ，但仍然...)及其关系，以及您确切想要的规范很难回答(绑定两个tbls"甚至都不是英语-尽管事实在sql中没有意义).
不过，我仍然有您想要的想法.尝试在第一个查询中添加子查询:

Without the table schema (I remember your previous question[^], but still...) and their relations, and the specification of what you want exactly it is difficult to answer ("bind two tbls" is not even in English - despite the fact that has no meaning in sql).
Still, I have my ideas what you want. Try adding a subquery to your first one:

select sb.subcate_name, sum(p.qty), (select pr.p_name from product pr where pr.subcate_id = sb.subcate_id) as p_name
    from subcategory sb 
      join product p on p.subcate_id = sb.subcate_id
    where sb.cate_id = @cate_id
    group by sb.subcate_name

这篇关于我如何绑定两个TBL(由2个选择查询返回)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！