Re: CREATE VIEW fails, but works as just a SELECT
Yes, but the select statement DOESN'T return the duplicate columns when I do it. That's my whole point. The exact same statement works fine as a select, but not a view.
Also i know the * is generally bad practise, but these tables are data that are imported from a 3rd party as world wide geoprahy info, not created by me and they wont be changing anytime in the forseable future. But the bigger question is why does the exact same statement work when the CREATE VIEW AS part is omitted? If I just do the select, then i get the records exactly as i want, but when I put create view as in front of it I get duplicate column error. Do I have to do a different type of JOIN maybe?
Subject
Written By
Posted
November 01, 2006 03:20AM
November 01, 2006 08:59AM
November 01, 2006 06:40PM
November 01, 2006 07:03PM
Re: CREATE VIEW fails, but works as just a SELECT
November 01, 2006 08:10PM
November 01, 2006 08:32PM
November 01, 2006 10:18PM
November 08, 2006 05:14PM
November 16, 2006 09:18AM
November 16, 2006 09:20AM
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.