Question

sql 这段语句报错 Incorrect syntax near the keyword 'select'

select b.string as [string1]
,a.[string2]
,a.[string3]
,a.[string4]
into #temp
FROM #tempStr a with(nolock)
inner join dbo..table1 b with(nolock)
where b.code = a.Id
错误信息：
Incorrect syntax near the keyword 'select'
Incorrect syntax near the keyword 'where'

Answer 1

select b.string as [string1]
,a.[string2]
,a.[string3]
,a.[string4]
into #temp
FROM #tempStr a with(nolock)
inner join dbo.table1 b with(nolock)
where b.code = a.Id

dbo..table 中多了一个点

追问

我已经找到问题了，谢谢