怎么实现SQL多表联查分页显示？（附有问题代码）

SELECT TOP 6* SONG.songName,SINGER.singerName
FROM 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' 附近有语法错误。