ERROR 1060 while creating a view

[Vinay]

Hi,
   I am trying to create a view by joining two tables.These tables have a 
common column which references their parent table. I get the following error 
when I try to create a view.

   
create view trn2 as select * from dbtmsg,dbtrbl where dbtmsg.accxsk=-1



ERROR 1060 (42S21): Duplicate column name 'accxsk'



Thank You,

Any help appreciated,

Vinay