Mark, Sorry to not clarify the connection between the word "join" and the SQL. Please refer to the manual (it's easy to use) for explanations, as mentioned earlier.
Further to Roger's comment: there is another terminology where you can write the words INNER JOIN or LEFT JOIN (and several others), but the equality relationships in the WHERE clause have been around for longer (and it's harder to teach this old dog new tricks). Accordingly I tend to think of this way as the easiest to comprehend, particularly when there are a number of joins to be defined. Regards, =dn ----- Original Message ----- From: "Roger Baklund" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Mark Worsdall" <[EMAIL PROTECTED]> Sent: 27 January 2002 17:32 Subject: RE: Can this can be done in a single SQL statement? > * Mark Wordsall > > So there is no join is this sql statement, I say this cos I see no word > > saying JOIN? > > Yes, there are. The comma separating table names in the FROM clause are > synonyms for 'INNER JOIN', and the actual joining is done in the WHERE > clause, where you match the different tables, in this case using > 'table_a.table_b_id=table_b.id'. > > -- > Roger > > > --------------------------------------------------------------------- > 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
