* 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
