select a.*,CONVERT(varchar(10),SendTime,23) as shorttime,b.CodeNumber,b.GoodsName,b.GoodsGuiGe,b.GoodsDanWei from [dbo].[OrderDetail] a left join Goods b on a.GoodsId=b.GoodsId
转载于:https://www.cnblogs.com/sulong/p/4829472.html
转载于:https://www.cnblogs.com/sulong/p/4829472.html