SELECT BillHistory.*,E.EmployeeName as WhoHoldName,EE.EmployeeName as FromWhoName
FROM BillHistory CS把BillHistory 的别名CS去掉,改为SELECT BillHistory.*,E.EmployeeName as WhoHoldName,EE.EmployeeName as FromWhoName
FROM BillHistory
left join EmployeeInfo as E
on E.EmployeeID=BillHistory.WhoHold
left join EmployeeInfo as EE on EE.EmployeeID=BillHistory.FromWho
WHERE (BillHistory.ID =
(SELECT MAX(BillHistory.ID)
FROM BillHistory
WHERE BillHistory.BillID = CS.BillID))
FROM BillHistory CS把BillHistory 的别名CS去掉,改为SELECT BillHistory.*,E.EmployeeName as WhoHoldName,EE.EmployeeName as FromWhoName
FROM BillHistory
left join EmployeeInfo as E
on E.EmployeeID=BillHistory.WhoHold
left join EmployeeInfo as EE on EE.EmployeeID=BillHistory.FromWho
WHERE (BillHistory.ID =
(SELECT MAX(BillHistory.ID)
FROM BillHistory
WHERE BillHistory.BillID = CS.BillID))
解决方案 »
- 一个SQL 2000服务器需要存放多家数据,在企业管理器中如何管理啊
- 清除数据库的unused和unallocate_space
- 有关删除sa的问题
- 请问,俺的是32bit XP,想装ms sql 2005 ,应装啥版本.... ms sql 2005 enterprise版,装上后不能用.......
- sql语句求救???
- SQL里面有逻辑型数据类型吗?有的话是哪个啊?
- 数据库连接问题...
- 关于显示数据库中所有表名的问题?
- 模糊比对
- 高手救命!!重复数据的汇总问题---急!!!!!!!!!(用别人的账号)
- SQL Server: 不知什么时候插入一条记录到另一表中
- 在线等,急!!!关于MSDE的问题!
SELECT BillHistory.*,E.EmployeeName as WhoHoldName,EE.EmployeeName as FromWhoName
FROM BillHistory
left join EmployeeInfo as E
on E.EmployeeID=BillHistory.WhoHold
left join EmployeeInfo as EE on EE.EmployeeID=BillHistory.FromWho
WHERE (BillHistory.ID =
(SELECT MAX(BillHistory.ID)
FROM BillHistory xxxx
WHERE xxxx.BillID = BillHistory.BillID))
FROM BillHistory
left join EmployeeInfo as E
on E.EmployeeID=BillHistory.WhoHold
left join EmployeeInfo as EE on EE.EmployeeID=BillHistory.FromWho
WHERE (BillHistory.ID =
(SELECT MAX(xxxx.ID)
FROM BillHistory xxxx
WHERE xxxx.BillID = BillHistory.BillID))
不行呀!
怎么办哪:(
FROM BillHistory
left join EmployeeInfo as E
on E.EmployeeID=BillHistory.WhoHold
left join EmployeeInfo as EE on EE.EmployeeID=BillHistory.FromWho
WHERE BillHistory.ID =
(SELECT MAX(BillHistory.ID)
FROM BillHistory
group by ID)