Hi. When I use a select to extract information of two tables using inner join the time response is slowly.
Thanks Carlos Rovetto P.d: I use Visual Basic 6.0 with ODBC to work with MySQL >From: "Thomas Edison Jr." <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: How to Connect two mySQL Tables >Date: Wed, 10 Jul 2002 03:15:35 -0700 (PDT) > >Hi, > >If i have two seperate mySQL Tables in my database, >with some information.. and i would like to connect >the two tables so as to get Relevant Data picked up >from the relevant Table and it's relevant fields. > >Do we need to use a Foriegn/Primary key for this >purpose? If so, how do you use them? I coudln't find a >suitable description on using the Foriegn Keys in the >mySQL Manual. > >Thanks, >T. Edison Jr. > > > >__________________________________________________ >Do You Yahoo!? >Sign up for SBC Yahoo! Dial - First Month Free >http://sbc.yahoo.com > >--------------------------------------------------------------------- >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 _________________________________________________________________ MSN Fotos: la forma más fácil de compartir e imprimir fotos. http://photos.msn.es/support/worldwide.aspx --------------------------------------------------------------------- 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