7,714
社区成员
发帖
与我相关
我的任务
分享请问用一条SQL语句怎么写这个[Update]？
三条语句.
SQL1: select c.name from [;database=%s].software as c where c.index= [;database=%s].main.software
SQL2: select b.index from software as b where b.name=SQL1的结果.
SQL3: update [;database=%s].main as a set a.Software=SQL2的结果;
rt. thx.
SQL1: select c.name from [;database=%s].software as c where c.index= [;database=%s].main.software
SQL2: select b.index from software as b where b.name=SQL1的结果.
SQL3: update [;database=%s].main as a set a.Software=SQL2的结果;
rt. thx.
...全文
请发表友善的回复…
发表回复
auly403 2006-07-14
- 打赏
- 举报
up
wwwwb 2006-07-14
- 打赏
- 举报
可以参考DLOOK UP，即使合成一条SQL语句，效率比较低。
auly403 2006-07-14
- 打赏
- 举报
m_strUpd.Format("update [;database=%s].main as a,software as b,[;database=%s].software as c \
set a.Software=b.index where a.software=c.index and b.name=c.name",m_strPathDb,m_strPathDb);
这样写还是不行.怎么办?
set a.Software=b.index where a.software=c.index and b.name=c.name",m_strPathDb,m_strPathDb);
这样写还是不行.怎么办?
