> > // the query > > $verify = "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]"; > ........................... > > My question: why - or how can - the columns ft.topic_id and ft.topic_title > come from the table forum_posts? > > In the original schema, there is no column called topic_title in the table > called forum_posts.
They don't. ft is aliased to forum_topics. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php