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中执行起来总提示“语法错误(操作符丢失)”,请各位高手帮忙看看是什么地方写错啦,谢谢!!
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中执行起来总提示“语法错误(操作符丢失)”,请各位高手帮忙看看是什么地方写错啦,谢谢!!
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'
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)
create table swdjfb(QY_ID int,KYRQ datetime,KYRQ_SWDJF int)
create table kpzb(QY_ID int)
create table sbzb(QY_ID int)
goSelect 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'
godrop table swdjzb,kpzb,sbzb,swdjfb
go--以上语句没什么问题
--以上语句没什么问题---------------------------
看錯誤提示,應該不是在MS SQL中運行的。