mysql> desc DZT_posts; +-----------------+-----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+-----------------------+------+-----+---------+----------------+ | post_id | mediumint(8) unsigned | | PRI | NULL | auto_increment | | topic_id | mediumint(8) unsigned | | MUL | 0 | | | forum_id | smallint(5) unsigned | | MUL | 0 | | | poster_id | mediumint(8) | | MUL | 0 | | | post_time | int(11) | | MUL | 0 | | | poster_ip | varchar(8) | | | | | | post_username | varchar(25) | YES | | NULL | | | enable_bbcode | tinyint(1) | | | 1 | | | enable_html | tinyint(1) | | | 0 | | | enable_smilies | tinyint(1) | | | 1 | | | enable_sig | tinyint(1) | | | 1 | | | post_edit_time | int(11) | YES | | NULL | | | post_edit_count | smallint(5) unsigned | | | 0 | | +-----------------+-----------------------+------+-----+---------+----------------+ 13 rows in set (0.00 sec) mysql> \! ls mysql> \! less test.txt mysql> desc DZT_posts_text; +--------------+-----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-----------------------+------+-----+---------+-------+ | post_id | mediumint(8) unsigned | | PRI | 0 | | | bbcode_uid | varchar(10) | | | | | | post_subject | varchar(60) | YES | | NULL | | | post_text | text | YES | | NULL | | +--------------+-----------------------+------+-----+---------+-------+ 4 rows in set (0.00 sec) mysql> help For the complete MySQL Manual online, visit: http://www.mysql.com/documentation For info on technical support from MySQL developers, visit: http://www.mysql.com/support For info on MySQL books, utilities, consultants, etc., visit: http://www.mysql.com/portal List of all MySQL commands: Note that all text commands must be first on line and end with ';' ? (\?) Synonym for `help'. clear (\c) Clear command. connect (\r) Reconnect to the server. Optional arguments are db and host. delimiter (\d) Set query delimiter. edit (\e) Edit command with $EDITOR. ego (\G) Send command to mysql server, display result vertically. exit (\q) Exit mysql. Same as quit. go (\g) Send command to mysql server. help (\h) Display this help. nopager (\n) Disable pager, print to stdout. notee (\t) Don't write into outfile. pager (\P) Set PAGER [to_pager]. Print the query results via PAGER. print (\p) Print current command. prompt (\R) Change your mysql prompt. quit (\q) Quit mysql. rehash (\#) Rebuild completion hash. source (\.) Execute a SQL script file. Takes a file name as an argument. status (\s) Get status information from the server. system (\!) Execute a system shell command. tee (\T) Set outfile [to_outfile]. Append everything into given outfile. use (\u) Use another database. Takes database name as argument. For server side help, type 'help contents' mysql> \t mysql> show tables; +----------------------+ | Tables_in_DZT | +----------------------+ | DZT_auth_access | | DZT_banlist | | DZT_categories | | DZT_config | | DZT_confirm | | DZT_disallow | | DZT_forum_prune | | DZT_forums | | DZT_groups | | DZT_posts | | DZT_posts_text | | DZT_privmsgs | | DZT_privmsgs_text | | DZT_ranks | | DZT_search_results | | DZT_search_wordlist | | DZT_search_wordmatch | | DZT_sessions | | DZT_sessions_keys | | DZT_smilies | | DZT_themes | | DZT_themes_name | | DZT_topics | | DZT_topics_watch | | DZT_user_group | | DZT_users | | DZT_vote_desc | | DZT_vote_results | | DZT_vote_voters | | DZT_words | +----------------------+ 30 rows in set (0.00 sec) mysql> \! less test.txt mysql> desc DZT_forums; +--------------------+-----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+-----------------------+------+-----+---------+-------+ | forum_id | smallint(5) unsigned | | PRI | 0 | | | cat_id | mediumint(8) unsigned | | MUL | 0 | | | forum_name | varchar(150) | YES | | NULL | | | forum_desc | text | YES | | NULL | | | forum_status | tinyint(4) | | | 0 | | | forum_order | mediumint(8) unsigned | | MUL | 1 | | | forum_posts | mediumint(8) unsigned | | | 0 | | | forum_topics | mediumint(8) unsigned | | | 0 | | | forum_last_post_id | mediumint(8) unsigned | | MUL | 0 | | | prune_next | int(11) | YES | | NULL | | | prune_enable | tinyint(1) | | | 0 | | | auth_view | tinyint(2) | | | 0 | | | auth_read | tinyint(2) | | | 0 | | | auth_post | tinyint(2) | | | 0 | | | auth_reply | tinyint(2) | | | 0 | | | auth_edit | tinyint(2) | | | 0 | | | auth_delete | tinyint(2) | | | 0 | | | auth_sticky | tinyint(2) | | | 0 | | | auth_announce | tinyint(2) | | | 0 | | | auth_vote | tinyint(2) | | | 0 | | | auth_pollcreate | tinyint(2) | | | 0 | | | auth_attachments | tinyint(2) | | | 0 | | +--------------------+-----------------------+------+-----+---------+-------+ 22 rows in set (0.00 sec) mysql> \! less test.txt mysql> select forum_id,forum_name from DZT_forums; +----------+--------------------------------------+ | forum_id | forum_name | +----------+--------------------------------------+ | 1 | The Paper | | 2 | The Website | | 3 | The Forum | | 4 | Your opinion about city policies | | 5 | Your Belief | | 6 | The Bible and You | | 7 | The Mayor's Performance | | 8 | Messages for the Congress | | 9 | Vice Mayor's Corner | | 10 | Messages to/from our Kabayans Abroad | | 11 | Tough Questions | | 12 | Welcome newbies and guests!!! | | 13 | Headlines | | 14 | Opinions | +----------+--------------------------------------+ 14 rows in set (0.00 sec) mysql> select a.forum_id,a.forum_name from DZT_forums as a,DZT_categories as b; +----------+--------------------------------------+ | forum_id | forum_name | +----------+--------------------------------------+ | 1 | The Paper | | 2 | The Website | | 3 | The Forum | | 4 | Your opinion about city policies | | 5 | Your Belief | | 6 | The Bible and You | | 7 | The Mayor's Performance | | 8 | Messages for the Congress | | 9 | Vice Mayor's Corner | | 10 | Messages to/from our Kabayans Abroad | | 11 | Tough Questions | | 12 | Welcome newbies and guests!!! | | 13 | Headlines | | 14 | Opinions | | 1 | The Paper | | 2 | The Website | | 3 | The Forum | | 4 | Your opinion about city policies | | 5 | Your Belief | | 6 | The Bible and You | | 7 | The Mayor's Performance | | 8 | Messages for the Congress | | 9 | Vice Mayor's Corner | | 10 | Messages to/from our Kabayans Abroad | | 11 | Tough Questions | | 12 | Welcome newbies and guests!!! | | 13 | Headlines | | 14 | Opinions | | 1 | The Paper | | 2 | The Website | | 3 | The Forum | | 4 | Your opinion about city policies | | 5 | Your Belief | | 6 | The Bible and You | | 7 | The Mayor's Performance | | 8 | Messages for the Congress | | 9 | Vice Mayor's Corner | | 10 | Messages to/from our Kabayans Abroad | | 11 | Tough Questions | | 12 | Welcome newbies and guests!!! | | 13 | Headlines | | 14 | Opinions | | 1 | The Paper | | 2 | The Website | | 3 | The Forum | | 4 | Your opinion about city policies | | 5 | Your Belief | | 6 | The Bible and You | | 7 | The Mayor's Performance | | 8 | Messages for the Congress | | 9 | Vice Mayor's Corner | | 10 | Messages to/from our Kabayans Abroad | | 11 | Tough Questions | | 12 | Welcome newbies and guests!!! | | 13 | Headlines | | 14 | Opinions | | 1 | The Paper | | 2 | The Website | | 3 | The Forum | | 4 | Your opinion about city policies | | 5 | Your Belief | | 6 | The Bible and You | | 7 | The Mayor's Performance | | 8 | Messages for the Congress | | 9 | Vice Mayor's Corner | | 10 | Messages to/from our Kabayans Abroad | | 11 | Tough Questions | | 12 | Welcome newbies and guests!!! | | 13 | Headlines | | 14 | Opinions | +----------+--------------------------------------+ 70 rows in set (0.00 sec) mysql> select a.forum_id,a.forum_name,b.cat_name from DZT_forums as a,DZT_categories as b; ERROR 1054 (42S22): Unknown column 'b.cat_name' in 'field list' mysql> \! less test.txt mysql> select a.forum_id,a.forum_name,b.cat_name from DZT_forums as a,DZT_categories as b where a.forum_id=b.forum_id; ERROR 1054 (42S22): Unknown column 'b.cat_name' in 'field list' mysql> select a.forum_id,a.forum_name from DZT_forums as a,DZT_categories as b where a.forum_id=b.forum_id; ERROR 1054 (42S22): Unknown column 'b.forum_id' in 'where clause' mysql> desc DZT_forums; +--------------------+-----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+-----------------------+------+-----+---------+-------+ | forum_id | smallint(5) unsigned | | PRI | 0 | | | cat_id | mediumint(8) unsigned | | MUL | 0 | | | forum_name | varchar(150) | YES | | NULL | | | forum_desc | text | YES | | NULL | | | forum_status | tinyint(4) | | | 0 | | | forum_order | mediumint(8) unsigned | | MUL | 1 | | | forum_posts | mediumint(8) unsigned | | | 0 | | | forum_topics | mediumint(8) unsigned | | | 0 | | | forum_last_post_id | mediumint(8) unsigned | | MUL | 0 | | | prune_next | int(11) | YES | | NULL | | | prune_enable | tinyint(1) | | | 0 | | | auth_view | tinyint(2) | | | 0 | | | auth_read | tinyint(2) | | | 0 | | | auth_post | tinyint(2) | | | 0 | | | auth_reply | tinyint(2) | | | 0 | | | auth_edit | tinyint(2) | | | 0 | | | auth_delete | tinyint(2) | | | 0 | | | auth_sticky | tinyint(2) | | | 0 | | | auth_announce | tinyint(2) | | | 0 | | | auth_vote | tinyint(2) | | | 0 | | | auth_pollcreate | tinyint(2) | | | 0 | | | auth_attachments | tinyint(2) | | | 0 | | +--------------------+-----------------------+------+-----+---------+-------+ 22 rows in set (0.00 sec) mysql> desc DZT_categories; +-----------+-----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+-----------------------+------+-----+---------+----------------+ | cat_id | mediumint(8) unsigned | | PRI | NULL | auto_increment | | cat_title | varchar(100) | YES | | NULL | | | cat_order | mediumint(8) unsigned | | MUL | 0 | | +-----------+-----------------------+------+-----+---------+----------------+ 3 rows in set (0.00 sec) mysql> select a.forum_id,a.forum_name,cat_title from DZT_forums as a,DZT_categories as b where a.cat_id=b.cat_id; +----------+--------------------------------------+------------------------------------------------+ | forum_id | forum_name | cat_title | +----------+--------------------------------------+------------------------------------------------+ | 1 | The Paper | Your Opinion About Us Matters | | 2 | The Website | Your Opinion About Us Matters | | 3 | The Forum | Your Opinion About Us Matters | | 12 | Welcome newbies and guests!!! | Your Opinion About Us Matters | | 4 | Your opinion about city policies | The Zamboanga City Government | | 7 | The Mayor's Performance | The Zamboanga City Government | | 8 | Messages for the Congress | The Zamboanga City Government | | 9 | Vice Mayor's Corner | The Zamboanga City Government | | 5 | Your Belief | Religion, Doctrine and Practice (English only) | | 6 | The Bible and You | Religion, Doctrine and Practice (English only) | | 11 | Tough Questions | Religion, Doctrine and Practice (English only) | | 10 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | | 13 | Headlines | Readers Comments | | 14 | Opinions | Readers Comments | +----------+--------------------------------------+------------------------------------------------+ 14 rows in set (0.02 sec) mysql> select a.forum_id,a.forum_name,cat_title from DZT_forums as a,DZT_categories as b where a.cat_id=b.cat_id; +----------+--------------------------------------+------------------------------------------------+ | forum_id | forum_name | cat_title | +----------+--------------------------------------+------------------------------------------------+ | 1 | The Paper | Your Opinion About Us Matters | | 2 | The Website | Your Opinion About Us Matters | | 3 | The Forum | Your Opinion About Us Matters | | 12 | Welcome newbies and guests!!! | Your Opinion About Us Matters | | 4 | Your opinion about city policies | The Zamboanga City Government | | 7 | The Mayor's Performance | The Zamboanga City Government | | 8 | Messages for the Congress | The Zamboanga City Government | | 9 | Vice Mayor's Corner | The Zamboanga City Government | | 5 | Your Belief | Religion, Doctrine and Practice (English only) | | 6 | The Bible and You | Religion, Doctrine and Practice (English only) | | 11 | Tough Questions | Religion, Doctrine and Practice (English only) | | 10 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | | 13 | Headlines | Readers Comments | | 14 | Opinions | Readers Comments | +----------+--------------------------------------+------------------------------------------------+ 14 rows in set (0.00 sec) mysql> select a.forum_id,a.forum_name,cat_title from DZT_forums as a,DZT_categories as b,DZT_posts as c where a.cat_id=b.cat_id and a.forum_id=c.forum_id; +----------+--------------------------------------+------------------------------------------------+ | forum_id | forum_name | cat_title | +----------+--------------------------------------+------------------------------------------------+ | 5 | Your Belief | Religion, Doctrine and Practice (English only) | | 6 | The Bible and You | Religion, Doctrine and Practice (English only) | | 10 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | | 10 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | | 10 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | | 10 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | | 10 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | | 10 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | | 10 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | | 11 | Tough Questions | Religion, Doctrine and Practice (English only) | | 12 | Welcome newbies and guests!!! | Your Opinion About Us Matters | | 12 | Welcome newbies and guests!!! | Your Opinion About Us Matters | | 12 | Welcome newbies and guests!!! | Your Opinion About Us Matters | | 12 | Welcome newbies and guests!!! | Your Opinion About Us Matters | | 12 | Welcome newbies and guests!!! | Your Opinion About Us Matters | | 13 | Headlines | Readers Comments | +----------+--------------------------------------+------------------------------------------------+ 16 rows in set (0.02 sec) mysql> select a.forum_id,a.forum_name,cat_title,c.post_id from DZT_forums as a,DZT_categories as b,DZT_posts as c where a.cat_id=b.cat_id and a.forum_id=c.forum_id; +----------+--------------------------------------+------------------------------------------------+---------+ | forum_id | forum_name | cat_title | post_id | +----------+--------------------------------------+------------------------------------------------+---------+ | 6 | The Bible and You | Religion, Doctrine and Practice (English only) | 2 | | 11 | Tough Questions | Religion, Doctrine and Practice (English only) | 3 | | 5 | Your Belief | Religion, Doctrine and Practice (English only) | 4 | | 10 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 5 | | 12 | Welcome newbies and guests!!! | Your Opinion About Us Matters | 6 | | 12 | Welcome newbies and guests!!! | Your Opinion About Us Matters | 7 | | 12 | Welcome newbies and guests!!! | Your Opinion About Us Matters | 8 | | 10 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 9 | | 10 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 10 | | 10 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 11 | | 12 | Welcome newbies and guests!!! | Your Opinion About Us Matters | 12 | | 12 | Welcome newbies and guests!!! | Your Opinion About Us Matters | 13 | | 10 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 14 | | 10 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 15 | | 10 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 16 | | 13 | Headlines | Readers Comments | 17 | +----------+--------------------------------------+------------------------------------------------+---------+ 16 rows in set (0.00 sec) mysql> select b.cat_id,a.forum_id,a.forum_name,cat_title,c.post_id from DZT_forums as a,DZT_categories as b,DZT_posts as c where a.cat_id=b.cat_id and a.forum_id=c.forum_id; +--------+----------+--------------------------------------+------------------------------------------------+---------+ | cat_id | forum_id | forum_name | cat_title | post_id | +--------+----------+--------------------------------------+------------------------------------------------+---------+ | 4 | 6 | The Bible and You | Religion, Doctrine and Practice (English only) | 2 | | 4 | 11 | Tough Questions | Religion, Doctrine and Practice (English only) | 3 | | 4 | 5 | Your Belief | Religion, Doctrine and Practice (English only) | 4 | | 5 | 10 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 5 | | 2 | 12 | Welcome newbies and guests!!! | Your Opinion About Us Matters | 6 | | 2 | 12 | Welcome newbies and guests!!! | Your Opinion About Us Matters | 7 | | 2 | 12 | Welcome newbies and guests!!! | Your Opinion About Us Matters | 8 | | 5 | 10 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 9 | | 5 | 10 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 10 | | 5 | 10 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 11 | | 2 | 12 | Welcome newbies and guests!!! | Your Opinion About Us Matters | 12 | | 2 | 12 | Welcome newbies and guests!!! | Your Opinion About Us Matters | 13 | | 5 | 10 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 14 | | 5 | 10 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 15 | | 5 | 10 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 16 | | 6 | 13 | Headlines | Readers Comments | 17 | +--------+----------+--------------------------------------+------------------------------------------------+---------+ 16 rows in set (0.00 sec) mysql> \! less test.txt mysql> select b.cat_id,a.forum_id,a.topic_id,a.forum_name,cat_title,c.post_id from DZT_forums as a,DZT_categories as b,DZT_posts as c where a.cat_id=b.cat_id and a.forum_id=c.forum_id; ERROR 1054 (42S22): Unknown column 'a.topic_id' in 'field list' mysql> select b.cat_id,a.forum_id,b.topic_id,a.forum_name,cat_title,c.post_id from DZT_forums as a,DZT_categories as b,DZT_posts as c where a.cat_id=b.cat_id and a.forum_id=c.forum_id; ERROR 1054 (42S22): Unknown column 'b.topic_id' in 'field list' mysql> select b.cat_id,a.forum_id,c.topic_id,a.forum_name,cat_title,c.post_id from DZT_forums as a,DZT_categories as b,DZT_posts as c where a.cat_id=b.cat_id and a.forum_id=c.forum_id; +--------+----------+----------+--------------------------------------+------------------------------------------------+---------+ | cat_id | forum_id | topic_id | forum_name | cat_title | post_id | +--------+----------+----------+--------------------------------------+------------------------------------------------+---------+ | 4 | 6 | 2 | The Bible and You | Religion, Doctrine and Practice (English only) | 2 | | 4 | 11 | 3 | Tough Questions | Religion, Doctrine and Practice (English only) | 3 | | 4 | 5 | 4 | Your Belief | Religion, Doctrine and Practice (English only) | 4 | | 5 | 10 | 5 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 5 | | 2 | 12 | 6 | Welcome newbies and guests!!! | Your Opinion About Us Matters | 6 | | 2 | 12 | 7 | Welcome newbies and guests!!! | Your Opinion About Us Matters | 7 | | 2 | 12 | 8 | Welcome newbies and guests!!! | Your Opinion About Us Matters | 8 | | 5 | 10 | 5 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 9 | | 5 | 10 | 9 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 10 | | 5 | 10 | 5 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 11 | | 2 | 12 | 8 | Welcome newbies and guests!!! | Your Opinion About Us Matters | 12 | | 2 | 12 | 8 | Welcome newbies and guests!!! | Your Opinion About Us Matters | 13 | | 5 | 10 | 10 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 14 | | 5 | 10 | 11 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 15 | | 5 | 10 | 12 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 16 | | 6 | 13 | 13 | Headlines | Readers Comments | 17 | +--------+----------+----------+--------------------------------------+------------------------------------------------+---------+ 16 rows in set (0.00 sec) mysql> qui -> ; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'qui' at line 1 mysql> select b.cat_id,a.forum_id,c.topic_id,a.forum_name,cat_title,c.post_id from DZT_forums as a,DZT_categories as b,DZT_posts as c where a.cat_id=b.cat_id and a.forum_id=c.forum_id; +--------+----------+----------+--------------------------------------+------------------------------------------------+---------+ | cat_id | forum_id | topic_id | forum_name | cat_title | post_id | +--------+----------+----------+--------------------------------------+------------------------------------------------+---------+ | 4 | 6 | 2 | The Bible and You | Religion, Doctrine and Practice (English only) | 2 | | 4 | 11 | 3 | Tough Questions | Religion, Doctrine and Practice (English only) | 3 | | 4 | 5 | 4 | Your Belief | Religion, Doctrine and Practice (English only) | 4 | | 5 | 10 | 5 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 5 | | 2 | 12 | 6 | Welcome newbies and guests!!! | Your Opinion About Us Matters | 6 | | 2 | 12 | 7 | Welcome newbies and guests!!! | Your Opinion About Us Matters | 7 | | 2 | 12 | 8 | Welcome newbies and guests!!! | Your Opinion About Us Matters | 8 | | 5 | 10 | 5 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 9 | | 5 | 10 | 9 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 10 | | 5 | 10 | 5 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 11 | | 2 | 12 | 8 | Welcome newbies and guests!!! | Your Opinion About Us Matters | 12 | | 2 | 12 | 8 | Welcome newbies and guests!!! | Your Opinion About Us Matters | 13 | | 5 | 10 | 10 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 14 | | 5 | 10 | 11 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 15 | | 5 | 10 | 12 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 16 | | 6 | 13 | 13 | Headlines | Readers Comments | 17 | +--------+----------+----------+--------------------------------------+------------------------------------------------+---------+ 16 rows in set (0.00 sec) mysql> select b.cat_id,a.forum_id,c.topic_id,c.posters_id,a.forum_name,cat_title,c.post_id from DZT_forums as a,DZT_categories as b,DZT_posts as c where a.cat_id=b.cat_id and a.forum_id=c.forum_id; ERROR 1054 (42S22): Unknown column 'c.posters_id' in 'field list' mysql> select b.cat_id,a.forum_id,c.topic_id,c.poster_id,a.forum_name,cat_title,c.post_id from DZT_forums as a,DZT_categories as b,DZT_posts as c where a.cat_id=b.cat_id and a.forum_id=c.forum_id; +--------+----------+----------+-----------+--------------------------------------+------------------------------------------------+---------+ | cat_id | forum_id | topic_id | poster_id | forum_name | cat_title | post_id | +--------+----------+----------+-----------+--------------------------------------+------------------------------------------------+---------+ | 4 | 6 | 2 | 2 | The Bible and You | Religion, Doctrine and Practice (English only) | 2 | | 4 | 11 | 3 | 2 | Tough Questions | Religion, Doctrine and Practice (English only) | 3 | | 4 | 5 | 4 | 2 | Your Belief | Religion, Doctrine and Practice (English only) | 4 | | 5 | 10 | 5 | 5 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 5 | | 2 | 12 | 6 | 2 | Welcome newbies and guests!!! | Your Opinion About Us Matters | 6 | | 2 | 12 | 7 | 3 | Welcome newbies and guests!!! | Your Opinion About Us Matters | 7 | | 2 | 12 | 8 | 3 | Welcome newbies and guests!!! | Your Opinion About Us Matters | 8 | | 5 | 10 | 5 | 3 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 9 | | 5 | 10 | 9 | 7 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 10 | | 5 | 10 | 5 | 7 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 11 | | 2 | 12 | 8 | 10 | Welcome newbies and guests!!! | Your Opinion About Us Matters | 12 | | 2 | 12 | 8 | 3 | Welcome newbies and guests!!! | Your Opinion About Us Matters | 13 | | 5 | 10 | 10 | 11 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 14 | | 5 | 10 | 11 | 11 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 15 | | 5 | 10 | 12 | 5 | Messages to/from our Kabayans Abroad | Zamboangueños Worldwide | 16 | | 6 | 13 | 13 | 2 | Headlines | Readers Comments | 17 | +--------+----------+----------+-----------+--------------------------------------+------------------------------------------------+---------+ 16 rows in set (0.00 sec) mysql> quit