28,390
社区成员
发帖
与我相关
我的任务
分享
sql="select *,c.classname from [news] n left join [class] c on n.classid=c.id"
rs.open sql,conn,1,3
while not rs.eof
response.write rs("classname")
rs.movenxet
wend
rs.close
sql="select *,c.classname from [news] n left [class] c on n.classid=c.id"
rs.open sql,conn,1,3
while not rs.eof
response.write rs("classname")
rs.movenxet
wend
rs.close
select *,c.classname from [news] n left [class] c on n.classid=c.id
select *.c.classname from [news] n left [class] c on n.classid=c.id