select
TID,
t.OID,
GoodsName as 货物名称,
GoodsTonnage as 货物重量,
GoodsPrice as 运输价格,
Days as 到达天数,
AppCompanyName = (select Company from Logistics where ID = AppCompany) as 接货公司
from TreatingOrderInfo as t
请问
AppCompanyName = (select Company from Logistics where ID = AppCompany) as 接货公司这个列 该怎么取别名啊?我上面那样写报语法错误AppCompanyName as 接货公司 = (select Company from Logistics where ID = AppCompany) 这样还是报语法错误...AppCompanyName 这个别名该怎么取?
解决方案 »
- 紧急求助下!!关于日期datetime转换的问题!
- 刚学SQL2000就觉得有点难!
- 有谁知道view和table中列的对应关系的表示那个?
- 红球号码有0、1、2、3、4、5、6个相同时如何统计出来
- 【处理历史表的问题】
- 请问select * from (select * from master) 为什么有语法错误?
- 查询问题
- bcp导入导出问题
- 请问一个数据库查询问题
- 一个让我苦恼不已的问题:用VB写成的数据库程序,在我的机器里运行很好,但是在客户机器里却出现不支持ODBC属性的错误,那位大虾遇到过类似的情况?又是如何解决的?哎,真是郁闷死了
- 求三个表的sql查询语句
- 如何优化这条sql语句
TID,
t.OID,
GoodsName as 货物名称,
GoodsTonnage as 货物重量,
GoodsPrice as 运输价格,
Days as 到达天数,
AppCompanyName = (select Company from Logistics where ID = AppCompany)
as 接货公司from TreatingOrderInfo as t
不能返回多条记录,不然会报错
t.TID,
t.OID,
t.GoodsName as 货物名称,
t.GoodsTonnage as 货物重量,
t.GoodsPrice as 运输价格,
t.Days as 到达天数,
L.Company as 接货公司
from TreatingOrderInfo as t left join Logistics as L
on t.AppCompany=L.ID可以这样
select
TID,
t.OID,
GoodsName as 货物名称,
GoodsTonnage as 货物重量,
GoodsPrice as 运输价格,
Days as 到达天数,
AppCompanyName = (select Company from Logistics where ID = AppCompany) as 接货公司--这里你给定义了两次别名,所以错了
--可以
AppCompanyName = (select Company from Logistics where ID = AppCompany)
--or
(select Company from Logistics where ID = AppCompany) as 接货公司from TreatingOrderInfo as t