hi List The problem is like this
There are two Tables A and B. what i want to do is find out all the records where a.id != b.id Both tables have close to 10000 records. so for every a.id it has to check table b 10000 times and that is what is creating problems. bcos this query takes hell lot of time to execute and mysql stops responding after some time. So is there some other way to find out records present in one table but not in other. Thanks you can mail me at [EMAIL PROTECTED] also Pradeep __________________________________________________________________________ http://dating.zeenext.com Log on to nextDATE. It's the next best thing to doing it. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
