% sql="select top 12 news.id,news.*,newstype.typename from news,newstype WHERE news.typeid=newstype.id order by news.id desc" set rs=db.execute(sql) %>