Re: Help on Oracle8i SQL Syntax to create VIEW

CREATE VIEW ENVELOPE_V AS
SELECT COMPANY.NAME, (COMPANY.ADDRESS ||' '|| COMPANY.CITY ||', '|| COMPANY.STATE) AS CONCATENATED_ADDRESS
FROM COMPANY Use the above for a general frame of deductive reference. There are obvious problems in your sql--whcih columns exist in COMPANY and WHICH exist in MAILING ADDRESS, and there is no join in your where. You're probably looking at something like:

CREATE VIEW ENVELOPE_V AS
SELECT COMPANY.NAME, (MAILING_ADDRESS.ADDRESS ||' '|| MAILING_ADDRESS.CITY ||', '|| MAILING_ADDRESS.STATE) AS CONCATENATED_ADDRESS FROM COMPANY, MAILING_ADDRESS
WHERE MAILING_ADDRESS.COMPANY_ID = COMPANY.ID "Unknown User" <unknown_at_unknown.com> wrote in message news:e56ddt43jrvhe72vh2hakcj86gk0e593do_at_4ax.com...
> Hi,
>
> I am trying to create a view by combining the address fields into one long
 address on Oracle 8i.
> What is the correct syntax? Thanks.
>
> SQL> CREATE VIEW ENVELOPE (COMPANY, MAILING_ADDRESS) AS
> 2 SELECT NAME, ADDRESS + " " + CITY + ", " + STATE
> 3 FROM COMPANY;
> SELECT NAME, ADDRESS + " " + CITY + ", " + STATE
> *
> ERROR at line 2:
> ORA-00904: invalid column name
Received on Fri Apr 13 2001 - 15:34:54 CEST