Hey all. I have two tables, T1 and T2, tied together with an ID column. In practice they should have a 1 to 1 relationship. In development I corrupted my DB so there are some rows in T1 that don't have associated rows in T2. I'm bad and didn't back up before I started messing up my dev environment
I feel like this is pretty basic, but I don't know how to DELETE FROM `T1` WHERE (there are no associated rows in T2). I'd appreciate any help.