Question

sql将两张表里查到得数据在一张表里显示

我要在第一眼张表里查询出 一条数据 在第二张表里查出第二条数据 但是这两张表 没有必然的联系select S_Price as total from SPInfo where S_ID in(select S_ID from feeInfo)
select count(S_ID) as totals from FeeInfo group by S_ID要将这两个的结果 显示为一张表的两个字段

Answer 1

select a.total,b.totals into 新好差历表友搜庆神名 from
(select S_Price as total from SPInfo where S_ID in(select S_ID from feeInfo) ) as a,
(select count(S_ID) as totals from FeeInfo group by S_ID) as b

Answer 2

用条子查询就唯猜搞定了呀，我没理解错你要的效果吧指指型？select S_Price as total ,(select count(S_ID) as totals from FeeInfo group by S_ID) as '第二条语句字逗则段' from SPInfo where S_ID in(select S_ID from feeInfo)

Answer 3

select S_Price as total from SPInfo where S_ID in(select S_ID from feeInfo)
如散仿果两张表没有必然联系，你为什么还用冲带纤到嵌套表行首呢？
select distinct COUNT(S_ID) over(partition by S_ID) ,S_Price as total
from FeeInfo ,SPInfo

Answer 4

为什么不用视图？你本来要悔此解决的问题是什么？怎么用这样的方法处理问题？很怪。烂拿直接问你的原饥前搭始问题，让大家帮你想个合适的算法。

Answer 5

可以使用连接查询，join