Re: Simple Select (You'd think)

using (item_id) WHERE old.item_id IS NULL; See the manual <http://dev.mysql.com/doc/mysql/en/Rewriting_subqueries.html> for more. Michael Richard Williams wrote: This is my first post so forgive me if I put it in the wrong place or screwed it up in some way. I have two tables, "ne

Simple Select (You'd think)

This is my first post so forgive me if I put it in the wrong place or screwed it up in some way. I have two tables, "new" and "old" and I want to show all rows in one table that do not appear in the other table. I tried this select from the manual section "14.1.8.3 Subqueries with ANY, IN, and