select * from link a ,paylog b where exist(select * from paylog Where b.Custid=a.Custid Group by b.Custid having conunt(b.Custid)<1) and Deaddate between'2001-01-01'and'2001-01-31';说我Invalid use of keyword.和SELECT有错。
解决方案 »
- 一个Excel读取类,程序写的很乱,不知道该怎么搞了,大家给看看
- 为什么当执行Connection.Close时,数据库连接实际上没有立即断开?
- <<笑话>>
- 一个小问题,(是不是ShellExecuter的BUG??)
- 如何使用ADO连接SQL Server 2000数据库?
- 急:在通过代理上网的环境下如何发送SMTP邮件??
- 在线求助,谁有关于D7报表的资料或教材,来者有分
- 谁能搞到这个软件的源码?或用DELPHI写段实现其主要功能的代码...................!
- 请问Delphi怎样写代码把图片文件保存到SQL Server2000内呀
- 扫描的条码
- 中国式会计凭证货币金额控件(delphi7版)
- 这里有谁在用Delphi2010.建个package项目看看.有没生成bpl?
Invalid use of keyword.
Token: select
Line Number: 1无法理解了。
你还不如直接说明下要做什么;表结构关系;
from link a
inner join
(select Custid
from paylog Group by b.Custid having count(b.Custid)<1) b on b.Custid = a.Custid
where a.Deaddate between'2001-01-01'and'2001-01-31'
运行了你的还是要报错,提示为:
Invalid use of keyword.
Token: select
Line Number: 4
eg:inner join 或left join ......
以下是一個多級關聯的SQL語句:SELECT *,
CASE BuyerCode WHEN BuyerCode THEN(SELECT COLDSC FROM HR_Zone WHERE COLBCODE=F.BuyerCode ) ELSE NULL END AS COLDSC,
CASE BuyerCode WHEN BuyerCode THEN(SELECT COLPEO FROM HR_Zone WHERE COLBCODE=F.BuyerCode ) ELSE NULL END AS COLPEO,null as ts
FROM
(
SELECT *,
CASE COLTYPE WHEN COLTYPE THEN ( SELECT COLBCODE FROM HR_BuyerCode WHERE COLCODE=COLxB )ELSE NULL END AS BuyerCode
FROM
( select c.*,d.COLRQ from
( select
Account_Id,
Full_Name as COLNAME,
CSRQ as COLBRQ,
JCRQ as COLCRQ,
CB as COLBP,
BMID as COLCODE,
BM as COLBM,
kb as COLKB,
XB as COLXB,
BC as BC,
ZJQF as COLTYPE,
ZJ as ZJ,
JN as JN,
BYXX as BYXX,
SF as SF
,B.*
from Res_User_Temp a left join HR_MOUTH b on a.Account_Id = b.COLAID where a.bc<>'26'
) c left join HR_Pact d on c.COLAID = d.COLAID
) E
) F where F.COLAID IS NOT NULL
Invalid use of keyword ---错误的使用关键字段
检查一下是不是在建数据库表时的字段不合法,或者里面有系统保留参数作为字段名;
按照这个方向看看吧
现在这名提示错误更怪,说的是。
Capability not supported.
我是在SQL Explorer 调试的。
同时使用sqlserver中的视图图形化设计工具,结合多表关联的测试表和数据。可以看出左联、右联,内联的效果。
楼主有时间来问,不如自己去看书,更节约学习时间。