Hi Aaron, > Having a problem with a query that's returning 486,057 results when it > most definitely should NOT be doing that. > > I have two tables: > > 1 for a list of customers that purchase product A, another for customers > who purchased product B. > > Columns are: > > Id > First > Last > Email > > I am trying to compare table 1 to table 2 to get a result set that gives > me the contact info (table columns) for those whose email addresses in > table 1 DON'T EQUAL those in table two. > > In table one I have 2026 records > In table two I have 240 records > > The query is this: > > SELECT * FROM producta_customers AS t1, productb_customers AS t2 WHERE > t1.email != t2.email > > When I do this query. I get 486,057 results returne. > > Where am I going wrong? Any ideas?
What do you want to do? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
