see IS NOT On Thu, Oct 07, 2004 at 07:22:23PM -0700, Jason Williard wrote: > I know that it is possible to do this, though I don't know how. > > I have 2 tables containing information about trouble tickets. One of the tables > (table2) contains information about every ticket ever received, including tickets > that were deleted from the system. For this reason, table2 has ~450,000 records > where table1, which holds the good tickets, has only ~4500. I would like to clear > the useless data out of table2, but don't want to run 450,000 queries to compare > them one row at a time. The two tables share a common id, though one is referred to > as tickid while the other is referred to as ticketidchar. > > Is there an easy way, using just a few queries, to select all the rows in table2 > where ticketidchar does not exist in table1? > > Thank You, > Jason -- __________________________ Brooklyn Linux Solutions
So many immigrant groups have swept through our town that Brooklyn, like Atlantis, reaches mythological proportions in the mind of the world - RI Safir 1998 DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002 http://fairuse.nylxs.com http://www.mrbrklyn.com - Consulting http://www.inns.net <-- Happy Clients http://www.nylxs.com - Leadership Development in Free Software http://www2.mrbrklyn.com/resources - Unpublished Archive or stories and articles from around the net http://www2.mrbrklyn.com/downtown.html - See the New Downtown Brooklyn.... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
