求各位高手看一下这条SQL语句语法哪儿错啦？谢谢！！

[happyzyl]

Select djz.[QY_ID] AS djzq,
djz.[NSRMC_SWDJ],
djz.[SWJGBM],
djz.[NSRLX_SWDJ],
djf.[KYRQ_SWDJF],
zb.[QY_ID] AS zbq,
sb.[QY_ID] AS sbq From swdjzb AS djz
left join swdjfb AS djf on djz.[QY_ID]=djf.[QY_ID]
left join kpzb AS zb on djz.[QY_ID]=zb.[QY_ID]
left join sbzb AS sb on djz.[QY_ID]=sb.[QY_ID]
WHERE zb.[QY_ID] is null AND sb.[QY_ID] is null AND djf.[KYRQ]<'2006/12/31'

这条语句我在SQL中执行起来总提示“语法错误（操作符丢失）”，请各位高手帮忙看看是什么地方写错啦，谢谢！！

[paoluo]

你應該是用在ACCESS中吧。

try

Select djz.[QY_ID] AS djzq,
djz.[NSRMC_SWDJ],
djz.[SWJGBM],
djz.[NSRLX_SWDJ],
djf.[KYRQ_SWDJF],
zb.[QY_ID] AS zbq,
sb.[QY_ID] AS sbq From ((swdjzb AS djz
left join swdjfb AS djf on djz.[QY_ID]=djf.[QY_ID])
left join kpzb AS zb on djz.[QY_ID]=zb.[QY_ID])
left join sbzb AS sb on djz.[QY_ID]=sb.[QY_ID]
WHERE zb.[QY_ID] is null AND sb.[QY_ID] is null AND djf.[KYRQ]<'2006/12/31'

[yrwx001]

Select djz.[QY_ID] AS djzq,
djz.[NSRMC_SWDJ],
djz.[SWJGBM],
djz.[NSRLX_SWDJ],
djf.[KYRQ_SWDJF],
zb.[QY_ID] AS zbq,
sb.[QY_ID] AS sbq From swdjzb AS djz
left join swdjfb AS djf on djz.[QY_ID]=djf.[QY_ID]
left join kpzb AS zb on djz.[QY_ID]=zb.[QY_ID]
left join sbzb AS sb on djz.[QY_ID]=sb.[QY_ID]
WHERE zb.[QY_ID] is null AND sb.[QY_ID] is null AND djf.[KYRQ]<cast('2006/12/31' as datetime)

[x1234521]

我执行了，没有问题
没有语法错误

[paoluo]

ACCESS中多個關聯的話，需要把前面的關聯放在一對()中。

[lt1129]

你的KYRQ列是datetime类型的么？

[子陌红尘]

create table swdjzb(QY_ID int,NSRMC_SWDJ int,SWJGBM int,NSRLX_SWDJ int)
create table swdjfb(QY_ID int,KYRQ datetime,KYRQ_SWDJF int)
create table kpzb(QY_ID int)
create table sbzb(QY_ID int)
go

Select djz.[QY_ID] AS djzq,
djz.[NSRMC_SWDJ],
djz.[SWJGBM],
djz.[NSRLX_SWDJ],
djf.[KYRQ_SWDJF],
zb.[QY_ID] AS zbq,
sb.[QY_ID] AS sbq
From swdjzb AS djz
left join swdjfb AS djf on djz.[QY_ID]=djf.[QY_ID]
left join kpzb AS zb on djz.[QY_ID]=zb.[QY_ID]
left join sbzb AS sb on djz.[QY_ID]=sb.[QY_ID]
WHERE zb.[QY_ID] is null AND sb.[QY_ID] is null AND djf.[KYRQ]<'2006/12/31'
go

drop table swdjzb,kpzb,sbzb,swdjfb
go

--以上语句没什么问题

[paoluo]

libin_ftsafe(子陌红尘：TS for Banking Card) ( ) 信誉：105 Blog 加为好友 2007-07-06 15:23:08 得分: 0


--以上语句没什么问题

---------------------------
看錯誤提示，應該不是在MS SQL中運行的。

[happyzyl]

十分感谢楼上的各位！！！