How to delete rows from another table in SQLITE? Business by Steffy Alen - December 10, 2021December 20, 20210 I have these tables AT_WAR Primary key Ship_Name and War_ID Ship_Name War_ID First 1 Second 2 Third 3 SHIP Primary key Ship_Name Ship_Name Ship_Type_ID First S.1 Second S.2 Third S.3 FOURTH S.4 I want from the SHIP table to delete the ships that did not take part in a war. If i want to show the ships that participates in a war i can use this command: SELECT DISTINCT SHIP.Ship_Name FROM SHIP INNER JOIN AT_WAR ON SHIP.Ship_Name = AT_WAR.Ship_Name I am using this command but did not work DELETE FROM SHIP INNER JOIN AT_WAR ON SHIP.Ship_Name = AT_WAR.Ship_Name WHERE AT_WAR.Ship_Name IS NULL; Thank you in advance!