RE: Delete query for records in table1 that aren't in table2

2002-04-25 Thread Roger Baklund
* Kim Cosgrove > This should be an easy sql question for someone. I've got 2 tables that > have a linked field (id) and I need to clean up records that are > in table1, > but no matching id in table2. This is how I can select them > > SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=tab

Delete query for records in table1 that aren't in table2

2002-04-25 Thread Kim Cosgrove
Hi Everyone, This should be an easy sql question for someone. I've got 2 tables that have a linked field (id) and I need to clean up records that are in table1, but no matching id in table2. This is how I can select them SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id WHERE