FROM table1 t1 LEFT JOIN table2 t2 ON t1.field=t2.field -----Original Message----- From: John Meyer [mailto:johnmeyer_1978@;yahoo.com] Sent: Wednesday, November 13, 2002 8:14 AM To: MySQL Mailinglist Subject: RE: How to link tables in MySQL
AFAIK, MySQL doesn't have any sort of referential integrity checks with fields. conceptually, you can do it, and write your program to force it, but the database itself doesn't have it. John Meyer P.S. shouldn't it be table1.fieldA -----Original Message----- From: R. Hannes Niedner [mailto:hannes.niedner@;gmx.net] Sent: Tuesday, November 12, 2002 1:55 PM To: MySQL Mailinglist Subject: Re: How to link tables in MySQL On 11/12/02 12:41 PM, "tmb" <[EMAIL PROTECTED]> wrote: > 2 - In MS Access you have to graphically connect the > table id fields to tell Access how the tables relate. > > How do you do this In MySQL... from the command line > I'm sure... just a code snippit or reference to one > would be nice... You join the tables using : WHERE fieldA.table1 = fieldB.table2 So check out the join syntax in the manual. /h --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
