Ford, Mike [LSS]" <[EMAIL PROTECTED]> writes: > You have a conceptual misconception. In effect, you need to read that query > as: > > "select ft.topic_id, ft.topic_title > from ( forum_posts as fp > left join forum_topics as ft > on fp.topic_id = ft.topic_id > ) > where fp.post_id = $_GET[post_id]" > > In other words, the left join of the two tables is treated as a single > virtual table, from which you could select any column of either original > table. ..................
Thanks Mike for the clear explanation. TR --- [This E-mail scanned for viruses by gonefishingguideservice.com] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
