通常，将整个联接移到一个子查询中，该子查询查找要删除的行的主键：
DELETE FROM something
WHERE id IN (SELECT something.id
FROM something
JOIN combinations ON something.field1=combinations.field1
AND something.field2=combinations.field2
WHERE combinations.something=1234)
如果您有复合主键，则可以使用rowid代替：
DELETE FROM something
WHERE rowid IN (SELECT something.rowid
FROM something
JOIN combinations ON something.field1=combinations.field1
AND something.field2=combinations.field2
WHERE combinations.something=1234)
如果您有复合主键，并且将该表创建为WITHOUT ROWID表，则必须将联接重写为相关子查询：
DELETE FROM something
WHERE EXISTS (SELECT 1
FROM combinations
WHERE field1 = something.field1
AND field2 = something.field2
AND field3 = 1234)
602392714
清零编程群