- 论坛徽章:
- 0
|
谢谢各位老大回贴。上面的语句在我的数据库里执行不了。
select a.A1,b.A2,a.A3 from TEMP_1 a left join (select A1,min(A2) as A2 from TEMP_2 group by A1 ) b on a.A1=b.A1 执行这句话提示如下:
Incorrect syntax near the keyword 'select'.
Server Message: Number 102, Severity 15
Server 'SYBASE', Line 1:
Incorrect syntax near ')'.
update TEMP_01 a,(select A1,min(A2) as A2 from TEMP_02 group by A1) b set a.A2=b.A2 where a.A1=b.A1 执行这句提示如下:
Incorrect syntax near 'b'.
Server Message: Number 102, Severity 15
Server 'SYBASE', Line 1:
Incorrect syntax near '='.
么办法了。我只能是通过过渡表来实现了。
再次感谢各位。谢谢。 |
|