两个记录集rst1(x,y,w),有两条记录
(1,2,a)
(3,4,b)
rst2(z,w),有两条记录
(5,a)
(7,b)
如何得到一个记录集rst3(x,y,z)
(1,2,5)
(3,4,7)
rst1的w字段与rst2的w字段相等.
想各位请教原代码,谢谢!
(1,2,a)
(3,4,b)
rst2(z,w),有两条记录
(5,a)
(7,b)
如何得到一个记录集rst3(x,y,z)
(1,2,5)
(3,4,7)
rst1的w字段与rst2的w字段相等.
想各位请教原代码,谢谢!
在select的时候不就行了
select tst1.a,tst1.b,tst2.c from tst2 right join tst1 on tst2.c=tst1.c
Dim res1 As Recordset
Set db1 = OpenDatabase(YouDBFilePath, True, False)
sqlStr = "select rst1.x,rst1.y,rst2.z from rst1,rst2 where rst1.w=rst2.w"
Set rst3 = db1.OpenRecordset(sqlStr)
select rst1.x,rst1.y,rst2.z from tst2 right join tst1 on tst2.z=tst1.z