jakeyoung

Thanks very much, I'll give that a go.CheersJake

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