Jessica, What you can do is do a join. This accomplishes exactly what you want. Here is a example SELECT for you:
SELECT t1.Badge, t1.FirstName, t1.LastName, t2.demographics FROM people AS t1, info AS t2 WHERE t1.Badge = t2.Badge; This allows you to take two tables, and do a select result of what you want from which ever table you desire. I have been able to do a 5 table join like this, and I have not noticed ANY slowdown. I hope this helps!! -- Mike Eggleston -----Original Message----- From: Jessica Tishmack [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 12:52 PM To: David Felio Cc: [EMAIL PROTECTED] Subject: Re: multiple tables with same fields > Jessica Tishmack wrote: > Basically, I want to merge two tables together, then do a select on the > resulting table. But I want to do this without having to actually create > a new merged table > > > Perhaps you want a MERGE table? > http://www.mysql.com/doc/M/E/MERGE.html Thanks...but I want to do this without having to actually create a new merged table...hmm...this might be trickier than I thought. > > > -- > David Felio Software Developer [EMAIL PROTECTED] > Information Network of Arkansas > http://www.AccessArkansas.org > > --------------------------------------------------------------------- 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