sql 连接查询结果
select tb_Stock.Type,tb_Commodity.CommodityName,
tb_Company.CompanyName,count(tb_Reckoning.CommodityId)+1 as 借款次数,convert(varchar(8),tb_Stock.StockDate,112) union tb_Stock.id as 单据编号
from tb_Company,tb_Stock,tb_Commodity ,tb_Reckoning
where tb_Commodity.id=tb_Stock.CommodityId
and tb_Company.id=tb_Stock.CompanyId
and tb_Stock.Type='进货信息'
and tb_Reckoning.CommodityId=tb_Stock.id
group by tb_Stock.Type,tb_Commodity.CommodityName,
tb_Company.CompanyName,tb_Stock.StockDate,tb_Stock.id
单据编号结果怎样实现 时间日期+‘0000000’+id 这样的形式?首先我想实现时间日期+id ,怎样实现?