Basic MySQL question

MySQL v4.0.23a

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.

Thanks all.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!