这个sql 语句，总提示语法，各位兄弟，有语法错误？

[石工记]

select * into OrderVehicle from (select a.TruckOrder, a.[Creater],a.[CreatedDate],b.[OrderNo],b.[CompanyName],b.[CompanyCode],b.[CustomerAbbr],b.[CustomerCode],b.[CustomerNO],b.[Origin],b.[OriginCode],b.[OriginLoad],b.[OriginLoadCode],b.[Dest],
b.[DestCode],b.[Discharge],b.[VehicleType],b.[VehicleLength],Convert(varchar(16),b.[ReqPickDate],120) as 'ReqPickDate',b.[TransTimeLtd],
Convert(varchar(16),a.ArrivedTime,120) as 'ArrivedTime',Convert(varchar(16),a.LeaveTime,120) as 'LeaveTime',a.Remark,
c.[AutoID],c.[VehicleNo],c.[Supplier],c.[VehicleLength],c.[VehicleType],c.[Driver],c.[Phone],c.[BankName],c.[BankNo],c.[PayObject],c.[PrePay],c.[BanlanceType],c.[Retainage],a.[LastModifiedBy],Convert(varchar(16),a.[LastModifiedDate],120) as 'LastModifiedDate'
from [TO_TruckOrder] a inner join [TO_Order] b on a.OrderNO=B.OrderNo
inner join [TV_Req_Vehicle] c on a.[VehicleAutoID]=c.AutoID)

[石工记]

select d.* into OrderVehicle from (select a.TruckOrder, a.[Creater],a.[CreatedDate],b.[OrderNo],b.[CompanyName],b.[CompanyCode],b.[CustomerAbbr],b.[CustomerCode],b.[CustomerNO],b.[Origin],b.[OriginCode],b.[OriginLoad],b.[OriginLoadCode],b.[Dest], b.[DestCode],b.[Discharge],b.[VehicleType],b.[VehicleLength],Convert(varchar(16),b.[ReqPickDate],120) as 'ReqPickDate',b.[TransTimeLtd], Convert(varchar(16),a.ArrivedTime,120) as 'ArrivedTime',Convert(varchar(16),a.LeaveTime,120) as 'LeaveTime',a.Remark, c.[AutoID],c.[VehicleNo],c.[Supplier],c.[VehicleLength],c.[VehicleType],c.[Driver],c.[Phone],c.[BankName],c.[BankNo],c.[PayObject],c.[PrePay],c.[BanlanceType],c.[Retainage],a.[LastModifiedBy],Convert(varchar(16),a.[LastModifiedDate],120) as 'LastModifiedDate' from [TO_TruckOrder] a inner join [TO_Order] b on a.OrderNO=B.OrderNo inner join [TV_Req_Vehicle] c on a.[VehicleAutoID]=c.AutoID) d

[石工记]

消息 8156，级别 16，状态 1，第 1 行 多次为 'd' 指定了列 'VehicleLength'

[Yole]

select  d.*  into OrderVehicle 
from 
(select a.TruckOrder, a.[Creater],a.[CreatedDate],b.[OrderNo],b.[CompanyName],b.[CompanyCode],b.[CustomerAbbr],b.[CustomerCode],b.[CustomerNO],b.[Origin],b.[OriginCode],b.[OriginLoad],b.[OriginLoadCode],b.[Dest],
b.[DestCode],b.[Discharge],b.[VehicleType],b.[VehicleLength],Convert(varchar(16),b.[ReqPickDate],120) as 'ReqPickDate',b.[TransTimeLtd],
Convert(varchar(16),a.ArrivedTime,120) as 'ArrivedTime',Convert(varchar(16),a.LeaveTime,120) as 'LeaveTime',a.Remark,
c.[AutoID],c.[VehicleNo],c.[Supplier],c.[VehicleLength] as VehicleLength1
,c.[VehicleType],c.[Driver],c.[Phone],c.[BankName],c.[BankNo],c.[PayObject],c.[PrePay],c.[BanlanceType],c.[Retainage],a.[LastModifiedBy],Convert(varchar(16),a.[LastModifiedDate],120) as 'LastModifiedDate'
from [TO_TruckOrder] a inner join [TO_Order] b on a.OrderNO=B.OrderNo
inner join [TV_Req_Vehicle] c on a.[VehicleAutoID]=c.AutoID) d 

字段有重复，我把VehicleLength这个字段 as成VehicleLength1

[yooq_csdn]

去掉 into 还报错吗？ 错误信息你到是发上来啊

[qq_17482963]

在最后加个别名x,就可以了

[Yole]

select  d.*  into OrderVehicle 
from 
(select a.TruckOrder, a.[Creater],a.[CreatedDate],b.[OrderNo],b.[CompanyName],b.[CompanyCode],b.[CustomerAbbr],b.[CustomerCode],b.[CustomerNO],b.[Origin],b.[OriginCode],b.[OriginLoad],b.[OriginLoadCode],b.[Dest],
b.[DestCode],b.[Discharge],b.[VehicleType],b.[VehicleLength],Convert(varchar(16),b.[ReqPickDate],120) as 'ReqPickDate',b.[TransTimeLtd],
Convert(varchar(16),a.ArrivedTime,120) as 'ArrivedTime',Convert(varchar(16),a.LeaveTime,120) as 'LeaveTime',a.Remark,
c.[AutoID],c.[VehicleNo],c.[Supplier],c.[VehicleLength],c.[VehicleType],c.[Driver],c.[Phone],c.[BankName],c.[BankNo],c.[PayObject],c.[PrePay],c.[BanlanceType],c.[Retainage],a.[LastModifiedBy],Convert(varchar(16),a.[LastModifiedDate],120) as 'LastModifiedDate'
from [TO_TruckOrder] a inner join [TO_Order] b on a.OrderNO=B.OrderNo
inner join [TV_Req_Vehicle] c on a.[VehicleAutoID]=c.AutoID) d 

[石工记]

是的，字段有重复