sql 语句

insert 
into TransportExecution(ID,UnitID,Status,InitiateTime,ReceiveTime,MaterialStatus,Initiator,Receiver)
values(1,1,'运输中','2011-5-2','2011-5-2','完好','admin','admin')
-----------------------插入数据到TransportExecution


select * from TransportExecution


select F.status as 运输状态 ,A.Quantity as 数量,B.id as 所属运输计划编号,B.StartPos as 起始地点,B.Destination as 目的地,B.SendDepart as 发料单位,convert(varchar(10),B.requiredDate,120) as 需求日期,B.shift 班次,C.ID as 所属物料计划,C.MaterialName as 物料名称,C.Quantity as 需求数量,C.id as 所属物料计划编号,E.Creator as 条码生成人,convert(varchar(10),E.CreateTime,120)  as 条码生成时间 from TransportPlan  B,TransportUnit A,MaterialPlan C,Barcode as E ,TransportExecution as F where A.transportNo=B.id and A.transportNo=C.iD  and E.Code=A.code and F.UnitID=A.ID and  A.id=1