In a 'cleanup' routine - I want to delete all rows in the SpecType table that DON'T appear in the SpecValue table.....
So if this would work:
DELETE from SpecType WHERE SpecTypeID<>SpecValueID;
Of course this doesn't work.....
Can I do this in 'one transaction' or do I HAVE to SELECT the unused rows THEN delete them?
Ian
Oh yeah - it's for MYSQL.....
come to think of it though...
How do I query for values that aren't in the other table anyway????
