且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

删除具有内部联接的行?

更新时间:2023-01-17 20:02:30

对于子选择,您没有右括号.试试这个:

You don't have a closing parenthesis for your subselect. Try this:

DELETE FROM network
WHERE ROWID in (
    SELECT ROWID 
    FROM track 
    INNER JOIN network ON (track.ROWID = network.trackId) 
    WHERE network.timestamp > track.stopTime OR network.timestamp < track.startTime 
       AND network.trackId = X
)

如果这不起作用,请尝试发布您的实际语法错误.

If that doesn't work, try posting your actual syntax error.