hihi, Have problem deleting from a table when "no" is not found in 2 other tables. Delete table cant use alias like tbOne a Delete from tbCost1 where Not EXISTS (select * from tbCost2 a Inner Join tbCost3 b where a.no='222' and b.no='222') and no='222' neither is this working: Delete from t1 a left join t2 b on t2.no=t1.no left join t3 c on t3.no=t1.no where a.no='222' and b.no is null and c.no is null
Welcome to the forum! I think you're missing the table alias right after DELETE Delete A from t1 a left join t2 b on t2.no=t1.no left join t3 c on t3.no=t1.no where a.no='222' and b.no is null and c.no is null