Dear Listmembers, I have two tables, one is an updated version of the other. How can I find only the "new" items on the newer table?
Table "newtest" mom flowers dad tools dave video matt magazine Table "newtest2" mom flowers dad tools dave video matt magazine gram book erin flower Query: SELECT newtest2.Name,newtest2.Item FROM newtest2,newtest WHERE newtest2.Name != newtest.Name GROUP BY Name; This query returns only the 4 common records when I use "=" but returns all 6 records when I use "<>" or "!=". I want only the last 2 items from Table newtest2. What am I doing wrong? Thanks, Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
