Quoting [EMAIL PROTECTED]: > Good, you recognize the need to perform two separate aggregates (GROUP > BYs) and compare the separate results... In fact, you may need two temp > tables so that you can (INNER / LEFT) JOIN one to the other. (Yes, I can > think of a query that works without the second temp table but I think it's > kludgey and would rather not post it.) > > To find same name and count > > CREATE TEMPORARY TABLE tmpCount1
I've been staying away from TEMPORARY TABLEs for two reasons: 1) irrational fear of the unfamiliar 2) safety: not being exactly sure what happens if two clients try to create a TEMPORARY TABLE by the same name at the same time 3) not being exactly sure what happens if my client is killed before I can DROP TEMPORARY TABLE and I end up with millions of temporary tables filling up my disk. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]