Question

sql查询两个数据库

有连个数据库 clyw 和clcw 都在同一个服务器上

里面有相同的表spkfk，spkfjc 和 相同的商品资料

现在要查询连个数据库 相同的商品资料的数量做对比

希望得到的结果是clyw库的商品001 数量为100
clcw库的商品001 数量为90
希望高手能写出语句
我会追加100分的

Answer 1

select clyw..spkfk.商品001，clyw..spkfk.数量，clcw..spkfjc.商品001，clcw..spkfjc.数量 from clyw..spkfk,clcw..spkfjc where clyw..spkfk.商品001=clcw..spkfjc.商品001;

其实就是在表前加库名和模式名，数据库.模式.表名,如果模式是dbo则可以省略。

Answer 2

<%

DbIp = "(local)"
DbName1 = "data1"
DbName2 = "data2"
DbUser = "sa"
DbPass = "sa"

StrConn1 = "Driver={SQL Server};server=" & DbIp & ";uid=" & DbUser & ";pwd=" & DbPw & ";database=" & DbName1 & ";"
StrConn2 = "Driver={SQL Server};server=" & DbIp & ";uid=" & DbUser & ";pwd=" & DbPw & ";database=" & DbName2 & ";"

Set conn1 = Server.Createobject("ADODB.Connection")
Set conn2 = Server.Createobject("ADODB.Connection")
conn1.open StrConn1
conn2.open StrConn2

SQLDATA1=conn1.execute("select count(*) from 表")(0)
SQLDATA2=conn2.execute("select count(*) from 表")(0)

response.write "表1:" & SQLDATA1 & "表2:" & SQLDATA2
%>

连接列子出来了，你在修改下吧

Answer 3

select a.商品名称,a.商品数量,b.商品数量 from clyw.dbo.spkfk as a join clcw.dbo.spkfjc as b on a.商品编号=b.商品编号

Answer 4

select t1.商品ID,t1.数量,t2.数量 from clyw..spkfk t1,clcw..spkfjc t2
where t1.商品ID=t2.商品ID

没看大明白你的问题，不知道这样对不对

Answer 5

select *
clyw..spkfk
where 商品=001 and 数量为=100
union
select *
from clcw..spkfjc
where 商品=001 and 数量为=90
在确保你2长clyw..spkfk 和from clcw..spkfjc 的列完全一样
如果不一样，那么取出你系那个要的字段替代*