摘要: 查询数据库字段Album_Media_view,然后在后面添加字段seekSELECT *, ISNULL ((SELECT TOP 1 seek FROM lastPlay lp WHERE lp.mediaID = Album_Media_view.MediaID AND lp.albumID = Album_Media_view.AlbumID AND lp.sessionID='User19834g09834ngv0n'), 0) AS seekFROM Album_Media_viewWHERE (AlbumID = 4)表原来的结构:查询后的结构:这里用到了sele 阅读全文
posted @ 2012-01-05 11:33 Mygirl 阅读(255) 评论(0) 推荐(0) 编辑