mysql> create view marcs_view as select item_id, item_md5, item_md5, content from items,items_text where items.item_id=items_text.item_id_fk;
ERROR 1060 (42S21): Duplicate column name 'item_md5'
mysql> create view marcs_view as select item_id, item_md5, content from items,items_text where items.item_id=items_text.item_id_fk;
Query OK, 0 rows affected (0.08 sec)
mysql> select * from marcs_view where item_id= 41;
+---------+----------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| item_id | item_md5 | content |
+---------+----------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 41 | 6cae494f16327cf874005f096021e3ce | Information Builders unveiled a new version of its WebFocus BI tool set at its annual Summit User Conference held this week in Las Vegas.
<p><a href="http://feeds.computerworld.com/~a/Computerworld/TopNews?a=bfv30k"><img src="http://feeds.computerworld.com/~a/Computerworld/TopNews?i=bfv30k" border="0"></img></a></p><img src="http://feeds.computerworld.com/~r/Computerworld/TopNews/~4/118737521" height="1" width="1"/> |
+---------+----------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.13 sec)
mysql>