create table #dbfTable
(code int , [open] decimal)
insert into #dbfTable
(code , [open])
select code , [open]
from openrowset
('msdasql','driver=microsoft visual foxpro driver;sourcetype=dbf;sourcedb=D:\qh(1)','select * from [all.dbf]')inner join all_code on #dbfTable.code = all_code.code
我加了最后一个inner join就报错了应该如何写这个语句??
(code int , [open] decimal)
insert into #dbfTable
(code , [open])
select code , [open]
from openrowset
('msdasql','driver=microsoft visual foxpro driver;sourcetype=dbf;sourcedb=D:\qh(1)','select * from [all.dbf]')inner join all_code on #dbfTable.code = all_code.code
我加了最后一个inner join就报错了应该如何写这个语句??
(code int , [open] decimal)
insert into #dbfTable
(code , [open])
select code , [open]
from openrowset
('msdasql','driver=microsoft visual foxpro driver;sourcetype=dbf;sourcedb=D:\qh(1)','select * from [all.dbf]')
那等他执行完后里面有数据了怎么inner join 不用另外一个表能实现吗?
------------不是很懂你的意思。你兩個表的數據是一樣的,就沒有必要inner join了。通常inner join 的格式為Select A.* From A Inner Join B On A.ID = B.ID
(code int , [open] decimal)
insert into #dbfTable
(code , [open])
select code , [open]
from openrowset
('msdasql','driver=microsoft visual foxpro driver;sourcetype=dbf;sourcedb=D:\qh(1)','select * from [all.dbf]')你的#dbfTable和你的all.dbf的code , [open])這兩個字段的數據是一樣的。接下來,你是做什麼?更新?還是查詢?如果是查詢,就是
select A.* from #dbfTable A inner join all_code B on A.code = B.code
恩但是这样我如果要保存结果还要用另一个表保存吗? 这样好想很麻烦要写很多字段名。。
--------------
不用。create table #dbfTable
(code int , [open] decimal)
insert into #dbfTable
(code , [open])
select code , [open]
from openrowset
('msdasql','driver=microsoft visual foxpro driver;sourcetype=dbf;sourcedb=D:\qh(1)','select * from [all.dbf]')
你的語句可以改為這樣select code , [open] into #dbfTable
from openrowset
('msdasql','driver=microsoft visual foxpro driver;sourcetype=dbf;sourcedb=D:\qh(1)','select * from [all.dbf]')同樣的,接下來的語句可以這麼寫select A.* Into #T from #dbfTable A inner join all_code B on A.code = B.code