Hi all, I was wondering if someone could shed some light on a little query I have. I have 2 quite large tables (~100,000 entries each, ~90meg each) with exactly the same table structures, but some differing entries. Lets call them table1 and table2, with a structure of [id, name, description]. What I want to be able to do is find what entries are present in table2 that aren't in table1. I'm sure this should be a simple query but it escapes me at the moment. I would be very grateful if anyone could help me out and maybe shed some light on this
Right, I think this is what you're looking for: SELECT * FROM table2 LEFT JOIN table1 ON table1.name = table2.name WHERE table1.name IS NULL; Or something along those lines, you might have to swap the parameters around a litte. Trying to visualise these things without actually performing the query to test is a little hit and miss.