Hi, As I understand it an ANSI92 join is written as;
SELECT b.columnA FROM tableB AS b JOIN ON tableC AS c ON b.id = c.id Whereas the 'old' style would be; SELECT b.columnA FROM tableB AS b, tableC AS c WHERE b.id = c.id Personally I find the former much easier to read though not sure about the practical differences between them when the statements are executed. Regards, Matt -----Original Message----- From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]] Sent: 23 July 2002 18:23 To: Defryn, Guy Cc: '[EMAIL PROTECTED]' Subject: Re: Joins, ANSI 92 or the "old way" Hi. On Wed 2002-07-17 at 14:16:39 +1200, [EMAIL PROTECTED] wrote: > > I was wondering what advantages one has over > the other. > > I think the "old way" is easier but is it good enough? I have no clue what you are talking about and I am sure I am not the only one. Mind giving an example? Greetings, Benjamin. -- [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.377 / Virus Database: 211 - Release Date: 15/07/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.377 / Virus Database: 211 - Release Date: 15/07/2002 --------------------------------------------------------------------- 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
