jakeyoung

<{POST_SNAPBACK}>

By the way, try this:

SELECT *FROM InterestForm

When you are trying to execute the view, you are not calling it properly. A view is essentially a new table as far as you are concerned (for querying purposes). The columns are: Property, Address, Type, Price, aDate, SalesPerson, InterestLevel, Vendorand the view is named InterestFormIn your query to execute the view, you did not list a FROM and you listed columns that are not in your view (at least not with those labels).I am not sure why it picked INTEREST to makr as invalid identifier, but oh well. Let me know if the above works and if you have any questions about it.

<{POST_SNAPBACK}>

Please Help.I am trying to create a view in SQL but when I execute it I get the following message ORA-00904: "INTEREST": invalid identifier I have put my code in below, maybe someone could point me in the right direction.Enter statements:create view InterestForm (Property, Address, Type, Price, aDate, SalesPerson, InterestLevel, Vendor) asselect Property_Number, vAddress_Line1, Type, Price, Appt_Date, sName, interest, vSurnamefrom Property, Sales_Staff, Vendor; select Property_Number, vAddress_Line1, Type, Price, Appt_Date, sName, interest, vSurname *ERROR at line 2: ORA-00904: "INTEREST": invalid identifier