为什么下面的sql执行时会报：列名dates无效呢，是语法有错误吗

显示全部楼层 · 2011-3-3 09:50:18

可能在表D或E在有字段与dates冲突也可能dates是SQL的一个属性或方法。你最好改一下dates为别的字段名。...

千问 · 2011-3-3 09:50:18

select E.station_id,convert(varchar(50),D.start_time,105) as dates,sum(D.value_a+D.value_b+D.value_c) as energy_value fromdbo.emp_energy_daily as D left joindbo.emp_device_ba...

千问 · 2011-3-3 09:50:18

select E.station_id,convert(varchar(50),D.start_time,105) as dates,sum(D.value_a+D.value_b+D.value_c) as energy_value fromdbo.emp_energy_daily as D left joindbo.emp_device_ba...