Question

SQL 数据库中把查询出来的列怎样添加到另外查询出来的表中，谢谢各位大侠

select datediff(d,fdate,getdate()) as 距今时间 from ICStockBill where (select datediff(d,fdate,getdate()) as lattime)>30

select B.FNAME,b.faddress 地址,C.FNAME 专营业务员,B.FContact 联系人,B.FPhone 电话,MAX(A.FDATE) 最后购买日期
from ICStockBill A,t_Organization B,T_EMP C
where A.ftrantype=21 AND A.FSUPPLYID=B.FITEMID AND B.Femployee=C.FITEMID
group by B.FNAME,b.faddress,C.FNAME,B.FPhone,B.FContact

我想把距今时间加入到下面的这张表中，应该怎样写代码？谢谢

Answer 1

select
B.FNAME,
b.faddress 地址,
C.FNAME 专营业务员,
B.FContact 联系人,
B.FPhone 电话,
MAX(A.FDATE) 最后购买日期,
datediff(d, MAX(A.FDATE), getdate()) as 距今时间
from
ICStockBill A,
t_Organization B,
T_EMP C
where
A.ftrantype=21
AND A.FSUPPLYID=B.FITEMID
AND B.Femployee=C.FITEMID
group by
B.FNAME,
b.faddress,
C.FNAME,
B.FPhone,
B.FContact

这样的效果?

追问

嘿嘿 非常感谢 知道了