Jennifer Goodie" <[EMAIL PROTECTED]> writes: They don't. ft is aliased to forum_topics. ........................
That's right. ft is aliased to the forum_topics table. The query reads: ........... $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]"; ............. The question: How can the column that is called: ft.topic_title in the select statement above be taken from the table called forum_posts when it was not there in the schema? "SELECT ft.topic_id, ft.topic_title FROM forum_posts...[snipped] Thank you. 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