Re: ERROR 1060 while creating a view

2006-02-14 Thread SGreen
"Vinay" <[EMAIL PROTECTED]> wrote on 02/14/2006 02:29:45 PM: > 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 d

ERROR 1060 while creating a view

2006-02-14 Thread 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 colu