"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
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