* 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
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