摘要:
查询数据库字段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 阅读全文