dim myconn,strconn
set myconn = server.createobject("adodb.connection")
strconn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("13110866350.mdb")
myconn.open strconn
Set rs= Server.CreateObject("adodb.recordset")
rs.open "select a.Cpsb,b.Picture from Stylist as a left joun Casus as b on a.ID=b.StyID and b.idate=(select max(b.idate) from Casus where a.ID=b.StyID)",myconn,1,1
楼主,我自己建了测试数据,没有发现问题。
设计师表ID Name
1 zhang san
2 li si
3 wang wu
4 ddd
设计师作品表
ID Works Date
1 A 2006/08/04
1 B 2006/09/01
1 C 2006/10/08
2 N 2006/08/07
3 D 2006/08/09
3 M 2006/10/01
查询结果
ID Name Works Date
1 zhang san C 2006/10/08
2 li si N 2006/08/07
3 wang wu M 2006/10/01
4 ddd
帖子上交流很不方便。
能加我MSN吗?hhhdyj@hotmail.com
dim myconn,strconn
set myconn = server.createobject("adodb.connection")
strconn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("13110866350.mdb")
myconn.open strconn
Set rs= Server.CreateObject("adodb.recordset")
rs.open "select a.Cpsb,b.Picture from Stylist as a left joun Casus as b on a.ID=b.StyID and b.idate=(select max(b.idate from Casus where a.ID=b.StyID))",myconn,1,1