create view error while perform JOIN
Posted by:
Pujo Aji
Date: June 06, 2005 06:52AM
Hello,
Is that possible to do CREATE VIEW in a JOIN Syntax.
I write this kind of database command and receive error.
'CREATE VIEW tab1 AS SELECT * FROM customer JOIN TRANSACTION USING(CNo)'
mysql_exceptions.OperationalError: (1060, "Duplicate column name 'CNo'")
Subject
Written By
Posted
create view error while perform JOIN
June 06, 2005 06:52AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.