怎么实现SQL多表联查分页显示?(附有问题代码)
SELECT TOP 6* SONG.songName,SINGER.singerNameFROM songInfo AS SONG
INNER JOIN singerInfo AS SINGER
ON SONG.singerId = SINGER.singerID
WHERE songWordCount = '3'
AND SONG.songId NOT IN
(
SELECT TOP 6 SONG.songName,SINGER.singerName
FROM songInfo AS SONG
INNER JOIN singerInfo AS SINGER
ON SONG.singerId = SINGER.singerID
WHERE songWordCount = '3'
)
ORDER BY SONG.songId
消息 102,级别 15,状态 1,第 1 行
'SONG' 附近有语法错误。