SELECT A.DisTributeID,A.DistributeSn,A.DistributeTime,A.ChartMend,A.DistributeCount,
A.TechnicalReport,A.[Disk],A.TotalNum,A.ChartType,
C.ChartName,C.ChartSn,C.SeaAreaName,C.PortName,
D.CustomerName,A.InstoreID
FROM T_DISTRIBUTE as A,T_CHART_IN_STORE AS C,T_CUSTOMER as D
WHERE A.InstoreID=C.InstoreID and A.IsDelete='0' order by A.DistributeTime如题
A.TechnicalReport,A.[Disk],A.TotalNum,A.ChartType,
C.ChartName,C.ChartSn,C.SeaAreaName,C.PortName,
D.CustomerName,A.InstoreID
FROM T_DISTRIBUTE as A,T_CHART_IN_STORE AS C,T_CUSTOMER as D
WHERE A.InstoreID=C.InstoreID and A.IsDelete='0' order by A.DistributeTime如题
最好加上关系,inner join等等
加个distinct 试试
在那里加 啊? 好久不写sql了 都忘记了,帮我写一个
A.TechnicalReport,A.[Disk],A.TotalNum,A.ChartType,
C.ChartName,C.ChartSn,C.SeaAreaName,C.PortName,
D.CustomerName,A.InstoreID
FROM T_DISTRIBUTE as A,T_CHART_IN_STORE AS C,T_CUSTOMER as D
WHERE A.InstoreID=C.InstoreID and A.IsDelete='0' order by A.DistributeTime
: 'DistributeTime' 附近有语法错误。
A.TechnicalReport,A.[Disk],A.TotalNum,A.ChartType,
C.ChartName,C.ChartSn,C.SeaAreaName,C.PortName,
D.CustomerName,A.InstoreID
FROM T_DISTRIBUTE as A,T_CHART_IN_STORE AS C,T_CUSTOMER as D
WHERE A.InstoreID=C.InstoreID and A.IsDelete='0' order by A.DistributeTime
我写成这个样子了可是还是不行?
A.TechnicalReport,A.[Disk],A.TotalNum,A.ChartType,
C.ChartName,C.ChartSn,C.SeaAreaName,C.PortName,
D.CustomerName,A.InstoreID
FROM T_DISTRIBUTE as A left join T_CHART_IN_STORE AS C join T_CUSTOMER as D
on A.InstoreID=C.InstoreID and A.IsDelete='0' order by A.DistributeTime这样写不对,谁帮我改一下
将三个表的关系理清楚,A.InstoreID=C.InstoreID
A和D什么关系或者C和D什么关系也在where写清楚,根据啥关联的
A.TechnicalReport,A.[Disk],A.TotalNum,A.ChartType,
C.ChartName,C.ChartSn,C.SeaAreaName,C.PortName,
D.CustomerName,A.InstoreID
FROM T_DISTRIBUTE as A left join T_CHART_IN_STORE AS C on A.InstoreID=C.InstoreID
and join T_CUSTOMER as D on A.CustomerID=C.CustomerID
A.IsDelete='0' order by A.DistributeTime
换个思路考虑问题。