Delete Rows With Inner Join?

I have a SQLITE database with two tables. Table A has an integer timestamp and another integer column containing a row id referring to a row in table B which has two timestamps. I

Solution 1:

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

DELETEFROM network
WHERE ROWID in (
    SELECT ROWID 
    FROM track 
    INNERJOIN 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.