Delete rows with inner join?
You don't have a closing parenthesis for your subselect. Try this:
DELETE FROM networkWHERE 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.