Howdy, Stranger!

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

Categories

Basic MySQL question

tvientitvienti Member Posts: 230
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.

T
Sign In or Register to comment.