Re: discussion forum from j. meloni's book
| From: | Anthony Ritter | Date: | Wed, 13 Aug 2003 13:04:06 +0000 |
| Subject: | Re: discussion forum from j. meloni's book | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-159425@lists.php.net to get a copy of this message | ||
Ford, Mike [LSS]" <M.Ford@lmu.ac.uk> 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