is there any difference between: a) >>select lname, fname >>from person_tb, details_tb >>where mem_id = det_id >>and fin = "y";
and b) select lname, fname from person_tb where mem_id in (select det_id from details_tb where fin = "y") which one will execute faster ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
