Hi Henry,
You created an alias for a table columnname. But either you either you created the alias twice with the same name or you are refering to two columns (one in each table with the same name). Best regards Nils Valentin Tokyo/Japan 2003年 7月 16日 水曜日 23:35、Henry さんは書きました: > I have 2 tables with the following fields : > > table : publisher > field1: pub_id - Primary, int, auto > > table : titles > field1: title_id - Primary, int, auto > field1: pub_id - int > > Using sqlyog I noticed that the indexes had already been created for the > Primary keys but according to my tutorial I also had to create an index for > the foreign key. > I did this and then tried to run the following query : > > SELECT pubishers.pub_id, titles.pub_ID > FROM pubishers JOIN pubishers ON pubishers.pub_id = titles.pub_id > > It keeps giving me the following error : > > Error Code : 1066 > Not unique table/alias: 'pubishers' > > Can someone tell me what I am doing wrong ? -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
